Prev: Excel 2003 - Chart printing squashed... but not always!
Next: animated / motion / chart Excel
From: Alan on 2 Jul 2008 09:46
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

From: Headmistress05 on 2 Jul 2008 10:58
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
>
>
From: Alan on 2 Jul 2008 11:57
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.
>
>
From: ShaneDevenshire on 2 Jul 2008 15:14
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.
> >
> >
>
From: Alan on 2 Jul 2008 15:28
Shane,
Thanks! Alan
 |  Next  |  Last
Pages: 1 2
Prev: Excel 2003 - Chart printing squashed... but not always!
Next: animated / motion / chart Excel