![]() |
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? |
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