Changing only Legend Text

  • Thread starter Thread starter Alan
  • Start date Start date
A

Alan

Is there a way just to change the legend text, without affecting
the axis label in Excel 2003?

If I go to Source Data, it has one entry for those labels.

Thanks, Alan
 
In the chart, if you right-click the legend, there should be a tab to change
the font size. This should allow you to change the font only for the legend.
 
I was not clear. I want to change the actual text that appears in
the legend, not the font of it.
 
Hi Alan,

Here is one way, there are others:
1. Select the series on the chart, not the legend. Note that there is a
formula on the Formula Bar that looks like:
=SERIES("series1",A1:A10,B1:B10,1) or
=SERIES(,A1:A10,B1:B10,1)

Of course your formula has different references including the sheet names.

The first argument of the series function is the series name, it is what the
legend uses. Enter a name after the "(" and before the first ",". Enter the
name you want to use putting quotes around it like in the first example
above. Or refer to a cell:
=SERIES(C1,A1:A10,B1:B10,1) where C1 has the name you want to use.
 
Hi Alan,

to correctly indicate the status of the question you can click the Yes or No
buttons to the right of the questions.
 
Shane -

He's not using the MS web interface. He can't see those buttons (nor can I).

- Jon
 
Back
Top