Chart legends

users
#1

Hello,
I inserted a chart from a Calc table in LO 4.2.1, running Linux-Mint-16. Now
I find that I cannot change the text displayed within the legend. It simply
displays "Row 1, Row 2, Row 3"...). As far as I can see, one can only change
the position of the legend. How do I define an arbitrary legend. Is there
maybe a way to somehow connect the various data rows of a chart with (e.g.)
a row/column in the Calc table on which the chart is based?
Regards
H. Stoellinger

#2

Heinrich Stoellinger wrote:

Hello,
I inserted a chart from a Calc table in LO 4.2.1, running Linux-Mint-16.
Now
I find that I cannot change the text displayed within the legend. It simply
displays "Row 1, Row 2, Row 3"...). As far as I can see, one can only
change
the position of the legend. How do I define an arbitrary legend.

1. Double-click the chart to start editing it, if not already in that mode.
2. From the menu: Format > Data Ranges...
3. Open the "Data Series" tab.
4. In the "Data Series" (left-hand) list, click the series for which you want to set the name.
5. In the "Data ranges" (right-hand) list, click "Name"
6. In the "Range for Name" (below that list), type the name you want to appear for the selected series, enclosed in double-quotes.
7. Repeat steps 4-6 for each series.
8. Click "OK".

Is there
maybe a way to somehow connect the various data rows of a chart with (e.g.)
a row/column in the Calc table on which the chart is based?

Yes. At step 6 above instead of typing the literal text (in quotes), enter a cell reference (without quotes). This needs to include the sheet name as well, e.g.:
   $Sheet1.$A$3
You can also click the icon to the right of the "Range for Name" box (it looks like a window with an up-pointing arrow), then click the cell in the spreadsheet, and Calc will automatically fill in the reference for you.

From the same dialog, you can also change the cells used for the series data (by selecting "y-Values" from the "Data ranges" list) and add new series to an existing chart. Useful if you add more data to the sheet beyond the range the chart was set up to use.

Regards
H. Stoellinger

I hope that helps.
Mark.

#3

Thanks, Mark,
I did actually manage to find out how to do this in the meantime...
In my opinion the procedure is not really self-evident. I tried doing it starting
with "Legend", but there one cannot change the text...
Thanks again...
Regards
Heinrich