Solved

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

Posted on 2009-05-08
2
654 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
2 Comments
 
LVL 20

Accepted Solution

by:
ltlbearand3 earned 500 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Open office calc - Extract url from hyperlink. 7 4,288
The type or namespace name 'unoidl' could not be found 17 2,308
My First Page! is out of screen 4 479
error in calc 7 483
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
When rebooting a vCenters 6.0 and try to connect using vSphere Client we get this issue "Invalid URL: The hostname could not parsed." When we get this error we need to do some changes in the vCenter advanced settings to fix the issue.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

864 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now