I'd like to use a custom legend for a diagram. Is that possible?
If it's helpful for anyone:
-
Xubuntu 13.10
-
LO 4.1
libreoffice-calc
I'd like to use a custom legend for a diagram. Is that possible?
If it's helpful for anyone:
Xubuntu 13.10
LO 4.1
Best Answer
Yes you can create a custom legend. To do so, you will have to provide the custom Data Range names separately in your spreadsheet (you can use the same sheet as our data, a separate sheet or even a separate
.ods
file). This is because the "data range name" is used in the legend by default; and the data range name is always set using a cell range reference.With the custom data range names prepared, you can reference them in the third step of the "
Insert Chart
" wizard (Menu "Insert
" -> "Chart...
"). In the following screenshot, i'm creating a chart from valuesB2:B4
, using the content ofA24
as name:You can also add or edit the legend later. To do so:
Chart edit
" mode (or right-click on the chart and select "Edit
");Data Ranges
", orFormat
" -> "Data Ranges
".This will show the following dialogue, the same as the third wizard step:
The "
Data series
" list box shows the data series name as it will appear in the legend.