Syntax

expression.PlotOrder

expression A variable that represents a Series object.

Remarks

You can set plot order only within a chart group (you cannot set the plot order for the entire chart if you have more than one chart type). A chart group is a collection of series with the same chart type.

Changing the plot order of one series will cause the plot orders of the other series in the chart group to be adjusted, as necessary.

Example

This example makes series two in Chart1 appear third in the plot order. The example should be run on a 2-D column chart that contains three or more series.

Visual Basic for Applications
Charts("Chart1").ChartGroups(1).SeriesCollection(2).PlotOrder = 3
Can I rearrange the order of plotting in a series group? change series sequence How do I assign a different index to a certain series in a plot? plot Plot data in a different sequence. plot order Plot Order Property PlotOrder PlotOrder Property

See also: