Edit

Series.PlotOrder property (Word)

  • Article

Returns or sets the plot order for the selected series within the chart group. Read/write Long.

Syntax

expression.PlotOrder

expression A variable that represents a Chart 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

The following example makes series two for the first chart in the active document appear third in the plot order. You should run the example on a 2D column chart that contains three or more series.

With ActiveDocument.InlineShapes(1) 
 If .HasChart Then 
 .Chart.ChartGroups(1).SeriesCollection(2).PlotOrder = 3 
 End If 
End With

See also

Series Object

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.