[calc] Simple chart issuse with data range

[lucadefi]

I have this file: data.ods (42.1 KB)
first 3 lines as example:

	france	japan	germany	uk
1960-12-31	62.225478000882	47.419238274462	84.310950194115	73.233967692103
1961-12-31	67.461644222035	57.266758179588	96.205728657727	77.741965703354

its structure is similar to the examle from : Chapter 3 Creating Charts and Graphs

but when i select $data.$A$1:$E$65 as data range and choose options:

• Data series in columns
• First row as label
• First column as label

the diagram will stay empty and have no lables and nothing added to the data series…
i dont understand why?

[EarnestAl]

You don’t have any numbers in there to graph. Click View > Value Highlighting and you can see that only the dates are numbers, everything else is text.

Convert the text to number first, see Calc Number text to Numeric data