[Issue] Legend names

Discuss the spreadsheet application
Post Reply
jas2803
Posts: 2
Joined: Mon Jul 21, 2008 4:36 am

[Issue] Legend names

Post by jas2803 »

I am getting very frustrated trying to use the charts in Calc 2.3
I created a line chart and I want to create a custom legend name but for some reason I find no way to edit the legends
it just says column L and Column M
Could some one be so kind as to instruct me how to rename the legend?
JAS
Last edited by Hagar Delest on Wed Nov 12, 2008 7:11 pm, edited 1 time in total.
Reason: Tagged the thread as issue (link to a bug report).
OOo 2.3.X on Ubuntu 7.x + Windows
jrkrideau
Volunteer
Posts: 3816
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada

Re: Legend names

Post by jrkrideau »

jas2803 wrote:I am getting very frustrated trying to use the charts in Calc 2.3
I created a line chart and I want to create a custom legend name but for some reason I find no way to edit the legends
it just says column L and Column M
Could some one be so kind as to instruct me how to rename the legend?
JAS
You need to add a row at the top of the columns and supply a name for the legend in that row. Make sure the option "use first row as labels" is checked.
LibreOffice 7.3.7. 2; Ubuntu 22.04
jas2803
Posts: 2
Joined: Mon Jul 21, 2008 4:36 am

Re: Legend names

Post by jas2803 »

well that is just stupid, I use the first row in calculations, will never do. I would of thought this could have just been edited, Excel allows you to name it whatever you want.
OOo 2.3.X on Ubuntu 7.x + Windows
Dave
Posts: 1011
Joined: Sun Dec 23, 2007 6:53 pm

Re: Legend names

Post by Dave »

Damn. I just bit my tongue.

David.
User avatar
Hagar Delest
Moderator
Posts: 32628
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Legend names

Post by Hagar Delest »

jas2803 wrote:Excel allows you to name it whatever you want.
Can you post a screenshot showing that (see here: How to attach a document here)?
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
mkepple
Posts: 1
Joined: Mon Nov 03, 2008 6:29 pm

Re: Legend names

Post by mkepple »

This thread is a couple months old now, but I just starting using version 3 of Calc and was trying to accomplish the same thing as the OP. Like the OP using a range of cells for names is not an option, nor should it be necessary. The OP is also correct that you can name a series to whatever you want to in MS Excel. Screen shots are attached.

Mk
Attachments
Excel Range 3.jpg
Excel Range 2.jpg
Excel Range 2.jpg (19.21 KiB) Viewed 27110 times
Excel Range 1.jpg
scottg
Posts: 1
Joined: Wed Nov 12, 2008 7:10 am

Re: Legend names

Post by scottg »

It may not be clear in this discussion that the chart's data range can contain discontiguous selection. i.e.
modify_chart_data_range.tiff
modify_chart_data_range.tiff (68.68 KiB) Viewed 27069 times
In this example $YTD references the sheet where the values come from; $A$8:A$20 is the range of values getting graphed; and $C3:$E$3 is the column names I want applied as legends.

This gets me this:
bar_graph
bar_graph
From this:
data_source
data_source
Picture 3.png (24.91 KiB) Viewed 27062 times
The help for my version of OO(NeoOffice version of OO for MacOSX) does not mention this is possible but it works. It is tricky to use as OO does not insert the semi-colon for you but tries to over-write your old selection.
User avatar
acknak
Moderator
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Legend names

Post by acknak »

Feature request: Issue 11890: Ability to edit legend text / modify series names
You can register there and add your vote (up to two) or comment.
AOO4/LO5 • Linux • Fedora 23
Post Reply