Changing only Legend Text

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" <ShaneDevenshire@discussions.microsoft.com> wrote in
message news:FACF8D56-6E3A-4EB4-8F03-5AC21650C02C@microsoft.com...
> 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
>>