PC Review


Reply
Thread Tools Rate Thread

Changing a charts series order

 
 
=?Utf-8?B?Q3NtaXRo?=
Guest
Posts: n/a
 
      18th Jul 2007
In eariler version of excel I was able to rearrange the series order of my
charts. This allowed me to view data that existed under multiple data series.
How do I change the series order?

Additionally, how do I change the order of the series included in the legend?
--
Csmith
 
Reply With Quote
 
 
 
 
Andy Pope
Guest
Posts: n/a
 
      19th Jul 2007
Hi,

You can change the series order via the select data dialog.
Select chart, Chart Tools > Design > Data > Select Data

The order of the items in the legend will change automatically.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Csmith" <(E-Mail Removed)> wrote in message
news:8B2EC214-E773-4DFE-A3EC-(E-Mail Removed)...
> In eariler version of excel I was able to rearrange the series order of my
> charts. This allowed me to view data that existed under multiple data
> series.
> How do I change the series order?
>
> Additionally, how do I change the order of the series included in the
> legend?
> --
> Csmith


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to change series plotting order without changing legend order? PatrickM Microsoft Excel Charting 6 2nd Dec 2009 07:43 PM
Changing order of series Tim Microsoft Excel Charting 2 23rd Jan 2008 12:32 PM
Series order vs Legend Order in Charts INTP56 Microsoft Excel Programming 2 6th Jan 2008 03:31 PM
Drawing Order of Data Series on Charts =?Utf-8?B?RWRkaWUgTWNHbG9uZQ==?= Microsoft Excel Charting 1 6th Sep 2007 04:08 PM
Disruption of order of data series in 100% stacked charts =?Utf-8?B?U3lsdmFpbg==?= Microsoft Excel Charting 4 21st Sep 2006 01:38 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:14 PM.