Changing "Series" Name

  • Thread starter Thread starter jerry chapman
  • Start date Start date
J

jerry chapman

When I create a chart with two different line dispays there is a legend at
the right side that says:
Series 1
Series 2
How can I change the to say:
John
Mary
?
 
Jerry,

To add series names to the legend, first click on your chart to activate it.
Then, go to the standard toolbar and hit Chart -> Source Data -> Series Tab.
In the Series dialog box you should see a field called "Name". You can add
a name for each of your two series in this field. To move between the two
series to individually add a name, click on "Series1" or "Series2" on the
left side of the dialog box under the "Series" option.

Another way to add series names is to add titles above each of your columns
before building your chart. For example, using the data below start column 1
in cell A2, column 2 in cell B1, and column 3 in cell C1.

Title1 Title2
a 2 3
b 3 4
c 2 3

After the data is entered into the spreadsheet, go to cell A1, activate the
Chart Wizard, and go through the prompts. The Chart Wizard should
automatically assign "Title1" to series 1 and "Title2" to series 2.
 
Click on the line representing the series you want to name and then click
your right mouse button over it. Choose 'Source data' from the menu and
then click on the Series tab at the top of the window. The series you
clicked on should be selected in the box on the left of the window and you
can type a name for it in the box on the right hand side, select the Series2
on the left when you have done the first series and you can name that as
well.

Andrea Jones
www.allaboutoffice.co.uk
 
Back
Top