Changing only Legend Text

[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

 

[Headmistress05]

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.

 

[Alan]

I was not clear. I want to change the actual text that appears in
the legend, not the font of it.

 

[ShaneDevenshire]

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.

 

[Alan]

Shane,
Thanks! Alan

 

[ShaneDevenshire]

Hi Alan,

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

 

[Jon Peltier]

Shane -

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

- Jon