How do you change legend on a chart
 

The descriptions used in the chart are taken from the series name? Values and
Category (X) axis labels are unchanged. Series name is the year. I need to
change from 2006 to 2007. Using Excel 2002.


Thanks.

How do you change legend on a chart
 

Source Data/ series tab will show you the name for each series, and allow
you to change it.
--
David Biddulph

"CCP" wrote in message
...
The descriptions used in the chart are taken from the series name? Values
and
Category (X) axis labels are unchanged. Series name is the year. I need to
change from 2006 to 2007. Using Excel 2002.


Thanks.

How do you change legend on a chart
 

I get an error message when I change - will have to capture message and
re-submit. Thanks.

"David Biddulph" wrote:

Source Data/ series tab will show you the name for each series, and allow
you to change it.
--
David Biddulph

"CCP" wrote in message
...
The descriptions used in the chart are taken from the series name? Values
and
Category (X) axis labels are unchanged. Series name is the year. I need to
change from 2006 to 2007. Using Excel 2002.


Thanks.

How do you change legend on a chart
 

I figured it out. It is linked to another worksheet that must be open also.

thanks again.

ccp

"David Biddulph" wrote:

Source Data/ series tab will show you the name for each series, and allow
you to change it.
--
David Biddulph

"CCP" wrote in message
...
The descriptions used in the chart are taken from the series name? Values
and
Category (X) axis labels are unchanged. Series name is the year. I need to
change from 2006 to 2007. Using Excel 2002.


Thanks.