LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 4,393
Default How to change series plotting order without changing legend or

Email me directly (get my addy from my website) and I will post back a
screen capture showing what I meant.
best wishes
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP

"PatrickM" wrote in message
...
Bernard, the popup menu doesn't have a 'Select Series' choice. It does
have
a 'Source data' choice but that doesn't have the functionality you
describe.

I recall earlier trying what you've described, where you can select a
series
and click the up and down arrows, just can't remember at the moment how I
got
there. But it didn't work anyway because in addition to changing the
legend
order, it also changed which series were plotted on top of which, and I
need
to avoid that. I have to change the legend without changing the plot, or
vice versa.

Thanks,
Patrick

"Bernard Liengme" wrote:

Right click the chart
Select Series Data fro popup menu
The Series Data dialog has two windows; in the larger one to the left you
will see the names of you data series listed
Select one of these and use the up/down arrow at the top of this window
to
reorder the legend entries
best wishes
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP

"PatrickM" wrote in message
...
My chart has four data series. They all plot as the same kind of line
and
they all plot against the same axes. Series 1 - 4 must be listed in the
legend in that order top to bottom; however on the chart itself they
must
be
superimposed on each other such that 4 is on the bottom and 1 plots on
top -
how do I force this? Excel defaults to plotting 1 on the bottom and 4
on
top.

In other words, Excel superimposes the series on the plot in the
opposite
order it lists them in the legend. Is there a way to reverse this?


Thanks,
Patrick


.

 
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 to change the series order in a LEGEND ONLY...not data Steve P[_2_] Charts and Charting in Excel 2 December 3rd 08 08:44 AM
Change series order in a legend ut_libet[_2_] Charts and Charting in Excel 2 June 11th 08 04:05 PM
How do I change the legend Series order in Excel 2007? Csmith Excel Discussion (Misc queries) 2 July 20th 07 10:26 PM
How do I change the Series plotting order in Excel 2007? Csmith Excel Discussion (Misc queries) 0 July 20th 07 08:52 PM
Changing order of series appearing in the legend on xy scatter plo JacksonRJones Charts and Charting in Excel 1 April 4th 06 11:00 PM


All times are GMT +1. The time now is 05:23 PM.

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"