[calc] Simple chart issuse with data range

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?

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

2 Likes