I have 2 columns of data - Time and Speed - so the 2 columns can be regarded as (x,y)-pairs. But when I choose Chart on the Insert-menu LibreOffice notoriously ignores all these data, no matter whether I place the cursor in the first row and column of the data OR I mark all the data.
In other words: When I mark all data in the 2 columns and choose Insert → Chart, LibreOffice has an empty data range… That does NOT make sense to me… Much less since I can see a blue box around my data…
The last time I used LibreOffice Calc, 6 weeks ago, there were no problems.
EDIT: I have attached the spreadsheet file.
New clockwise WITH stationary magnet-1.wav midlet 44100Hz Omdr.hast. trigger_level 3000.ods (71.2 KB)
Your data are text not numbers, no representable with the chart.
Use Menu/Data/Text-to-column for every column, once for column, to transform them in numbers.
Go to B2, and try again to insert the chart.
1 Like
Further to @mariosv answer, you might like to peruse the FAQ How to convert number text to numeric data
1 Like
Thank you for pointing out that the data was not imported as numbers but text…
So I imported the CSV-file again, choosing English as Language instead of Danish and choosing “Detect special numbers” (just to be sure, it’s probably not necessary). THAT worked!
The Data → Text to column - didn’t work immediately. I guess I forgot to choose English as Language.
Oh indeed it is necessary