Can't make a x/y chart

Hello,

It should be very easy to make a x/y chart.
I did it with ease at my work PC, and now at home its just not working:
HelpExcel.png

Why is that?

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

Copy the relevant data to a new workbook and upload that as your sample.

It might be, that i use '.' for a comma and excel needs a ',' ?
can I switch this setting? - on my pc from work it did exactly what I intended..

edit:
yes it is.

but if i change the decimal point to a point(.) - instead of a comma(,)

it still doesn't work - i had to manually reenter every single point to make it work.
(no the format of the cell stayed the same)

I cant reenter every decimal point every time(the data is gernerated by my programm)

Thanks if anyone can help me.

What I immediately see when I open your sample in post #1 is the little green triangle in each cell indicating "number stored as text". Looking closer at your picture in post #1, I notice that your values are all left aligned in the cell (the default setting for text. The default setting for numbers is left aligned). The surface problem seems to be that the numbers are stored as text and not real numbers. The surface solution, then, is to convert the text to real numbers. Strategies here: https://support.microsoft.com/en-us/...rs=en-us&ad=us

Reading between the lines, though, and I'm not sure that is a good final solution. If this were my project, I would look at where these numbers are coming from and try to understand why they are stored in Excel as text. An artifact of the way they were imported? Perhaps the result of a text manipulation function? Did somebody convert them to text and why? It seems to me that the better solution would be to understand why and how these numbers became text in the first place and try to deal with the issue there.

I imported the data automaticly from a.csv file

How did you import the data? Excel often treats .csv files in different ways depending on the importation process. Some procedures use whatever Excel chooses for default behavior with no possible input by the user. Other strategies (most of them involving the Text Import Wizard) have the ability to specify decimal and thousand separators while importing so you are not restricted to Excel's default behavior. If your import strategy does not give you any control over decimal settings, consider changing strategy to one that will allow you to control this option during import (use a .txt extension instead of .csv or use the import data command rather than file/open or whatever other options your version gives yoiu).

because, if you dont sepcify the language for interpreting the numbers, it will choose german in my case. (btw. swiss people use . for decimals but speak german.)

Remember that Excel is not making this choice on its own. Excel defaults to the settings in your OS (assuming you use Windows?). If Excel uses "," as decimal separator by default, that suggests that your system setting is to use comma for decimal separator. One needs to be careful changing global settings, but I would be tempted to look at the configuration in your OS and see if I wanted to change it to how I normally work.

Glad that helped. You can mark your thread "solved" by selecting the "thread tools" dropdown a the top of the first post and selecting "mark as solved" from that menu.