Chart order

[Boerge]

Hi,
I have made a combined chart with Line and Scatter graphs. Currently the
scatter graph is on top, but I want to have the Line graph on top of the
scatter dots. Is it possible to change the order by some settings, or do I
have to regenerate my chart and add the graphs in the order I want them to
show up. (It seems like the last graph added is shown on top)

 

[Jon Peltier]

Boerge -

Within each type of series, the series are ordered according to Plot Order. You can
change this on the Series Order tab after double clicking on a series. But you
notice that you can only change series relative to each other if they are the same
series type and if they are plotted on the same axis.

In the grand scheme of things, Area series are drawn under the rest, then come bar
and column, then line, and finally scatter series are always on top.

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