Ask Your Question

Can't edit legend name [closed]

asked 2014-12-28 01:52:05 +0200

Ramy Al Zuhouri gravatar image

I have made a graph in libreoffice calc, and in the legend by default the labels are "Column A", "Column B", etc... how do I edit the labels?

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-08-14 15:23:42.818825

2 Answers

Sort by » oldest newest most voted

answered 2014-12-28 05:45:17 +0200

ROSt52 gravatar image

Let me extend the correct answer of @eldon.dehart a bit.

If you select the data range including the name of the column (or row) of your data, Calc will automatically assign the name. However for this you must set the correct situation in the Chart wizard item DATA RANGE.

However, you can add column (or row) names later. Ideally they are above your column but they also can be somewhere else. To add the column name do:

Double click you chart to see 6 small little black squares around your chart and a grey frame

right click > select Data ranges > Tab Data series
select the series you want to change (left window Data series)and it should contain Column A, B, ..)
in the Data range window right > click Name > Click button at right side of Range of names > select a cell (or more) with the name of your column do above for each column and click OK at the end

I recommend to have a look at the free guides which you can download from

edit flag offensive delete link more

answered 2014-12-28 04:28:59 +0200

eldon.dehart gravatar image

it will use the title in the top of the column as the name. I think it is set up with the wizard when you make the chart.

edit flag offensive delete link more


This is definitely the best approach from the point of view of clear data structure in your spreadsheet --- If you consider your question as solved, please click the OK button to signal others that in this question is a working solution.

ROSt52 gravatar imageROSt52 ( 2014-12-28 09:35:10 +0200 )edit

Question Tools

1 follower


Asked: 2014-12-28 01:52:05 +0200

Seen: 19,823 times

Last updated: Dec 28 '14