View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default How to change series plotting order without changing legend order?

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