Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 122
Default How do I change the order of item in a legend for a chart?

How do I change the order of items in a legend for an Excel chart?
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default How do I change the order of item in a legend for a chart?

You can change the series order. Double click on a series and adjust the
settings in the Series Order tab.

Note that the order of appearance of different chart types cannot be mixed:
column series are always grouped, as are line series and XY series. In
addition, the order of series on the primary and secondary axes cannot be
changed.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Melissa" wrote in message
...
How do I change the order of items in a legend for an Excel chart?



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
Cannot change criteria on copied chart without changing original c Steve Charts and Charting in Excel 1 October 3rd 06 12:05 AM
How do I separate a chart from its legend Abby Karian Charts and Charting in Excel 3 September 1st 06 08:01 AM
Strange behaviour with legend in 2-Sided Chart Carlo Charts and Charting in Excel 2 August 30th 06 11:54 AM
Macro to change Chart Range when inserting a column Mark Charts and Charting in Excel 1 September 13th 05 01:12 PM
How do I change the order of the legend entries? Kerrin Charts and Charting in Excel 1 January 10th 05 10:03 PM


All times are GMT +1. The time now is 09:03 PM.

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

About Us

"It's about Microsoft Excel"