Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
CCP CCP is offline
external usenet poster
 
Posts: 3
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 8,651
Default 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.



  #3   Report Post  
Posted to microsoft.public.excel.charting
CCP CCP is offline
external usenet poster
 
Posts: 3
Default 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.




  #4   Report Post  
Posted to microsoft.public.excel.charting
CCP CCP is offline
external usenet poster
 
Posts: 3
Default 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.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I change the order of item in a legend for a chart? Melissa Charts and Charting in Excel 1 October 13th 06 02:50 AM
Chart Legend PCLIVE Charts and Charting in Excel 6 May 5th 06 01:42 AM
Change a legend in Pivot Chart Report SJT Excel Discussion (Misc queries) 2 February 28th 06 08:46 PM
Change the size of a chart marker in the legend Thea Charts and Charting in Excel 0 February 13th 06 08:38 PM
Change default settings for surface chart legend rmellison Charts and Charting in Excel 2 January 11th 06 09:19 AM


All times are GMT +1. The time now is 05:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"