ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Plot series on top of other series (https://www.excelbanter.com/excel-programming/385710-plot-series-top-other-series.html)

Mitch

Plot series on top of other series
 
I have a chart with several series'. I need to be able to set which series
plots 'on top' of the others. How (in VBA) do I accomplish this?

Jon Peltier

Plot series on top of other series
 
You handle it in VBA the same as manually, by changing the plot order and
axis group. Keep in mind that some chart types are always behind others,
despite plot order number. Area chart series are always behind any other
type; bars and columns are in front of Area; line series are in front of
these; and XY series are plotted on top of all others. Within a chart type,
series are listed from low plot order to high (high in front), and series on
the secondary axis appear in front of those on the primary axis.

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


"Mitch" wrote in message
...
I have a chart with several series'. I need to be able to set which series
plots 'on top' of the others. How (in VBA) do I accomplish this?





All times are GMT +1. The time now is 09:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com