Ask Your Question
2

Can't edit legend name

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 close merge delete

2 Answers

Sort by » oldest newest most voted
1

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 http://www.libreoffice.org/get-help/d...

edit flag offensive delete link more
0

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

Comments

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 16,263 times

Last updated: Dec 28 '14