Prev: m2 behinde a number and I want to sum
Next: chart legend changing when I use Select data
From: PatrickM on 1 Dec 2009 08:30
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
From: Bernard Liengme on 1 Dec 2009 09:01
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" <PatrickM(a)discussions.microsoft.com> wrote in message
news:1F21E198-13E8-4AFF-A340-C9D8D8499727(a)microsoft.com...
> 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

 | 
Pages: 1
Prev: m2 behinde a number and I want to sum
Next: chart legend changing when I use Select data