Ask Your Question

How do I edit the legend text in a LibreOffice Spreadsheet?

asked 2018-01-29 15:42:50 +0100

Carsten4711 gravatar image


How do I edit the legend text in a LibreOffice Spreadsheet? Now it is the column names.


br Carsten

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-01-29 18:15:59 +0100

Ratslinger gravatar image


Your question leaves one guessing. It seems you are asking about Legends in a Chart and not Spreadsheet (as charts may be in Writer, Base, etc.). If not, please clarify.

Legends in a spreadsheet chart can come from any cell. Typically you would use a row or column for these. Here is starting sample with no legends and a data range of B1:D5

image description

Double clicking the chart, then right click & selecting Data Ranges... gets:

image description

and checking row and column & changing data range will produce:

image description

You can also change a specific items legend:

image description

Location goes in Range for Name.

For much more info on this please see LO docs (found here) - Chapter 3.

edit flag offensive delete link more



Thanks a lot! It was precise what I was looking for.

br Carsten

Carsten4711 gravatar imageCarsten4711 ( 2018-02-01 15:01:25 +0100 )edit

If this answers your question please tick the ✔ (upper left area of answer). It helps others to know there was an accepted answer.

Ratslinger gravatar imageRatslinger ( 2018-02-01 15:31:30 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-01-29 15:42:50 +0100

Seen: 958 times

Last updated: Jan 29 '18