We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Calc: Display Text Labels on X-Axis [closed]

asked 2020-04-29 12:29:47 +0200

David.Cheshire gravatar image

updated 2020-12-02 01:16:02 +0200

Alex Kemp gravatar image

I have three columns of data which I am plotting an x/y chart. I wish to have the x-axis labels taken from the first column. This does not happen automatically, the x-axis is labelled 0 - 10 even though the correct range for the x-axis labels is shown when the chart is being created.

Previous questions and the LibreOffice Help implies that this can be corrected by editing the chart, right clicking on the x-axis, choosing "Format Axis" and in the "Scale" tab choose "Text" from a combo box. But in the scale tab I don't see such a combo box.

image description

I would be grateful if somebody would explain what I am doing wrong. I attach the example sheet: C:\fakepath\Untitled 1.ods

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-12-02 01:16:11.582665

1 Answer

Sort by » oldest newest most voted

answered 2020-04-29 13:26:51 +0200

Opaque gravatar image

updated 2020-04-29 13:29:58 +0200


XY(Scatter) chart type is suited for numerical data on both axis (e.g. function plot). Your column Year does not contain numerical data but text (though real calc dates would be numerical and could be used for x-axis in XY(Scatter) chart). Thus change your chart type to Line and you get your Year data as categories on the x-axis of your chart.

See the following modified file: C:\fakepath\DisplayTextLabels-Modified.ods

Hope that helps.

If the answer helped to solve your problem, please click the check mark (✔) next to the answer.

edit flag offensive delete link more


Perfect, thank you so much.

David.Cheshire gravatar imageDavid.Cheshire ( 2020-04-29 13:56:25 +0200 )edit

Question Tools

1 follower


Asked: 2020-04-29 12:29:47 +0200

Seen: 1,416 times

Last updated: Apr 29 '20