Data from csv in new chart component

Hi,
probably is a very simple question but I 'm not able to get X and Y value from my Sheet.
In the new chart component I want to read data from a csv file ( an excel sheet saved as csv ).
If I save one column in the file , it's ok but one axis is from the file and the other go automatic (0,1,2,3,4, etc ). Also the name of column is right but if I try add another column I get error.

I want to get both data from csv , X and Y. How to manage and save the csv file? I get always error 4101 invalid values.

thanks

Contents of csv please...
How are you bringing the csv data into the app ?
What type of chart are you hoping to make?

1 Like

Thanks for reply.
Very easy :see_no_evil:
image
I added chart component , then dataFile and set as source the csv file uploaded as assets, then dragged datafile in the chart to create and connect chartData2d .

image

csv data .

You are showing a screenshot of the spreadsheet, but not from the csv file itself... csv means comma separated value...
Just open your csv file and check if it looks like this

giorni,metri
12,23
23,18
44,32

Taifun

Yes, I saved it as csv from excel settings . I add it now sorry
sheet.csv (38 Bytes)

So the problem would be the comma ?

Yep, you need to replace the semi-colons ; with commas ,

1 Like

Thanks, I will try.
So the problem was the csv format used by excel, I will try google sheet too.
:+1:

More likely a locale setting in Excel (en-us or en-uk should use commas, continental Europe may use semi-colons)

Yes, I'm in Italy, I'm trying to change the settings

Google sheet saved in the right way . You know if is possible to show both values in the chart near the point ? Now I see only Y value and I use a notifier to show them on click

What type of chart are you trying to make ?

The chart component does not appear to provide for the setting of X/Y axis titles. To do this you will need to put the chart inside a vertical arrangement, then add a label below the chart. Then put the vertical arrangement inside a horizontal arrangement, and put a label to the left. Set the two labels with the values in the first row of your data, then remove the row from the list, then supply the data to the chart

image

1 Like

Yes I know about the title.
Something like this in the image , now chart shows only 1 values above the point.
I don't need a special chart I'm only testing the new component

I don't see any capability for (x,y) labelling of points in any of the charts.

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.