Chart order

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Boerge - 30 Sep 2004 12:49 GMT

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)

Signature

Thanks,
Boerge

Reply to this Message

Jon Peltier - 30 Sep 2004 13:42 GMT

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/
_______

> Hi,
> I have made a combined chart with Line and Scatter graphs. Currently
[quoted text clipped - 3 lines]
> order I want them to show up. (It seems like the last graph added is
> shown on top)

Reply to this Message