Re: [libreoffice-users] Chart legends

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.

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted