We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Course Of The Month
6 days, 5 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
How can I change data series labels on a chart in Open Office
Posted on 2009-05-08
I am creating my first charts in Open office 2.4. One of my charts consist of three rows of data, across 10-15 columns. The charts display as I want, but the data series label for all three rows of data, simply say "1". I would like to change them to something meaningful, but have not been able to figure out how.
I can send the .ods file for examination. I could not attach it to this question without converting it to an xls first, and thought that might strip out info you need on how I have the chart set up
Thank you in advance for your help.
I can send the .ods file for examination. I could not attach it to this question without converting it to an xls first, and thought that might strip out info you need on how I have the chart set up
Thank you in advance for your help.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2 Comments
I have OOo Calc 3.0, but I believe the steps are the same.
You will need to put your labels in three cells (for example in D1 you can put the label for series 1 - like "MySeries1").
Then right click on your chart and choose Data Ranges.
Select the Data Series Tab
Select each series
In Data Ranges, select name
In Range for Name put in the cell with the series name (for example D1 - or better yet, you can click select data range button on the right and then select the cell from your sheet.)
Click OK
Let me know how that works.
- Bear
You will need to put your labels in three cells (for example in D1 you can put the label for series 1 - like "MySeries1").
Then right click on your chart and choose Data Ranges.
Select the Data Series Tab
Select each series
In Data Ranges, select name
In Range for Name put in the cell with the series name (for example D1 - or better yet, you can click select data range button on the right and then select the cell from your sheet.)
Click OK
Let me know how that works.
- Bear
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
The conference as a whole was very interesting, although if one has to make a choice between this one and some others, you may want to check out the others. This conference is aimed mainly at government agencies. So it addresses the various compli…
In this blog we highlight approaches to managed security as a service. We also look into ConnectWise’s value in aiding MSPs’ security management and indicate why critical alerting is a necessary integration.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have.
In this…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface.
Change Cu…
Suggested Courses
Course of the Month6 days, 5 hours left to enroll
707 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.