?
Solved

How can I change  data series labels on a chart in Open Office

Posted on 2009-05-08
2
Medium Priority
?
662 Views
Last Modified: 2013-12-27
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.
0
Comment
Question by:tamray_tech
[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
 
LVL 20

Accepted Solution

by:
ltlbearand3 earned 2000 total points
ID: 24342074
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
0
 

Author Closing Comment

by:tamray_tech
ID: 31579691
Yes. That worked.

Thank you
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hey fellow admins! This time, I have a little fairy tale for you. As many tales do, it starts boring and then gets pretty gory. I hope you like it. TL;DR: It is about an important security matter, you should read it if you run or administer Windows …
This month, Experts Exchange’s free Course of the Month is focused on CompTIA IT Fundamentals.
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month10 days, 3 hours left to enroll

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question