| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to plot column chart with one series against multiple series. | Charts and Charting in Excel | |||
| how do I plot a data series against two series | Charts and Charting in Excel | |||
| Continuous series plot | Charts and Charting in Excel | |||
| chart data series -- plot a table as a single series | Charts and Charting in Excel | |||
| Plot points with same x-value in same series? | Charts and Charting in Excel | |||
Linear Mode
