Solved

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

Posted on 2009-05-08
2
656 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

This tutorial shows how to create a greeting card by combining two image layers and a text layer on a PC using a free image editing app.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

770 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