I am trying to create a diagram in Libreoffice calc, where the x axis labels shall be intervals and the y axis labels shall be shown in percentage.
My table looks like this:
0-40 100%
40-70 96%
70-100 92%
100-130 84%
>130 63%
Unfortunately, the y axis labels are shown correct, but the x axis labels look like this, instead of labeling it with the given intervals:
0 1 2 3 4 5 6 7
Where the diagram begins with x=1 and ends up with x = 6.
I did not find a way to make calc label the x axis as specified and also did not find any help online. Probably someone knows?
Edit the Data Series for your chart and let Categories point to the fields in your table that hold the labels.