I would like to change the text of the legends. The edit command only has DELETE legend, not the change as per the help command. So, maybe I have an old version but I get this message when I try to update:
Error reading data from the Internet.
Server error message.
Any ideas?
Thanks,
Eddie
[Solved] Change Legend
[Solved] Change Legend
Last edited by robleyd on Tue Feb 04, 2020 12:00 am, edited 1 time in total.
Reason: Tagged [Solved]
Reason: Tagged [Solved]
openoffice v.4 on win 10
Re: Change Legend
Please clarify what you mean by legends.
As to the server error, that is a long standing problem and has nothing to do with OpenOffice or the volunteer end users that supply pro-bono assistance.
As to the server error, that is a long standing problem and has nothing to do with OpenOffice or the volunteer end users that supply pro-bono assistance.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
Re: Change Legend
(No answer / clarification)RusselB wrote:Please clarify what you mean by legends.
What's going on here?ehj69a5 wrote:Thank you. Can you help with changing the legend text?
On Windows 10: LibreOffice 24.2 (new numbering) and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
---
Lupp from München
Re: Change Legend
Please upload a screen shot of a "legend" to help us understand what you're trying to change. We don't even know if this is in OpenOffice or something else. As far as I know, "legends" is not a term used in OpenOffice.
Edit: I looked up "legends" in Help. It seems that "legend" could refer to captions, charts, draw objects or drawings. Are you trying to edit one of those?
Edit: I looked up "legends" in Help. It seems that "legend" could refer to captions, charts, draw objects or drawings. Are you trying to edit one of those?
AOO 4.1.14 on Ubuntu MATE 22.04
Re: Change Legend
The legend is the labels in a Calc Chart, referenced to the first row of the data range by default.
See the strings "x", "y" on my attached image.
Did you meant this "Legend":
You can change the Legend labels of the chart by changing the cell content of the A1, B1 (in this case).
See the strings "x", "y" on my attached image.
Did you meant this "Legend":
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: Change Legend
After some time playing around, the attached is where I am. The legend on the right should be the dates of the three graphs and the last 2 show up at zero.
Thank you for your help.
Eddie
Thank you for your help.
Eddie
- Attachments
-
openoffice v.4 on win 10
Re: Change Legend
Would you mind to tell next time that you are talking of charts if you are?
On Windows 10: LibreOffice 24.2 (new numbering) and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
---
Lupp from München
Re: Change Legend
Sorry, I would like to change the legends of the attached chart.
openoffice v.4 on win 10
Re: Change Legend
Change the sheet cells in the top row.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Change Legend
ehj69a5,
please upload an .ods type sample file here.
please upload an .ods type sample file here.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: Change Legend
Sorry but I don't understand what sheet cells in the top row mean, the dates? nor where is "here" for the file samples?
openoffice v.4 on win 10
Re: Change Legend
'Here' means 'to the Forum', using the upload tab below the Submit button on 'Post Reply' or 'Full Editor' screens (it is not on 'Quick reply' screen).
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Re: Change Legend
The FIRST ROW (top row) of the data range of the Chart contains the STRINGS of the Legend.Sorry but I don't understand what sheet cells in the top row mean,
It is enough to change the string in the cells of the first row of the data range. Not needed to modify the Chart itself. The data cells are referenced in the Chart, they will refresh automatically.
There are cases, when the Chart-DataRange references will be broken. In this cases the legend will not refresh, and you must recreate the Chart.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: Change Legend
Got it. My file.ods
- Attachments
-
- Hearing Graph Mod.ods
- (17.82 KiB) Downloaded 109 times
openoffice v.4 on win 10
Re: Change Legend
Guys, got it working. Thank you all for your insight and help.
openoffice v.4 on win 10