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.

"Alan" wrote:

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

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

Headmistress05 wrote:
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.

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.

--
Cheers,
Shane Devenshire


"Alan" wrote:

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

Headmistress05 wrote:
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.

Shane,
Thanks! Alan

Hi Alan,

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


"Alan" wrote:

Shane,
Thanks! Alan

Shane -

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"ShaneDevenshire" wrote in
message ...
Hi Alan,

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


"Alan" wrote:

Shane,
Thanks! Alan