How do you change legend on a chart

[CCP]

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.

 

[David Biddulph]

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

 

[CCP]

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

 

[CCP]

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

thanks again.

ccp