Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index

Heinrich Stoellinger wrote:
I inserted a chart from a Calc table in LO 4.2.1, running Linux-Mint-16.
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
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.:
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.

H. Stoellinger

I hope that helps.

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.