I’ve built a line chart presenting 4 data series. Three of the lines are complete, but the fourth line stops about halfway through the data series. The data in the 4 data series are all in general number format. Why is this happening and how do I fix it?
Please upload your ODF type sample file here.
The data in the 4 data series are all in general number format.
Checking the format of a cell is not a method to determine the real data type. Use option
View -> Value Highlighting and see whether all data turn to blue color indicating type “Number”. If some values stay at/turn to black color, these are of type “Text”.
It might be that the remaining data in the 4th series is of type Text instead of numeric.
If so, see this FAQ for how to convert.