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

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...

On Sun, 02 Mar 2014 17:26:25 +0100, Mark Bourne <> wrote:

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.

Erstellt mit Operas revolutionärem E-Mail-Modul:

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.