Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 13
Default How can I manually sort the legend key?

I am trying to change the order my legend key is displayed? There should be
an obvious feature for this, but I cannot seem to find it? Any idea?
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default How can I manually sort the legend key?

You can rearrange the order of the series in the chart, but the order of the
legend entries is constrained beyond this. You cannot switch the order of
two series if one is on the primary axis and the other on the secondary, or
if the two series represent two different chart types (e.g., line vs,
column).

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


"Dani" wrote in message
...
I am trying to change the order my legend key is displayed? There should be
an obvious feature for this, but I cannot seem to find it? Any idea?



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
Can you sort worksheets other than manually? wltj Excel Discussion (Misc queries) 1 September 21st 06 05:55 PM
how do you make a graph legend sort high to low? David Maerzke Charts and Charting in Excel 2 December 4th 05 12:24 PM
Does this have to be done manually? Dorn Excel Discussion (Misc queries) 1 September 22nd 05 07:17 PM
Sort Legend Entries Coolboy55 Charts and Charting in Excel 1 August 28th 05 01:27 AM
Creating a bar graph manually WLMPilot Excel Worksheet Functions 5 June 23rd 05 07:00 PM


All times are GMT +1. The time now is 08:46 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"