Skip to content

Files

Latest commit

 

History

History
44 lines (25 loc) · 1.16 KB

Excel.Series.PlotOrder.md

File metadata and controls

44 lines (25 loc) · 1.16 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Series.PlotOrder property (Excel)
vbaxl10.chm578103
vbaxl10.chm578103
Excel.Series.PlotOrder
c74ba422-ca4d-db60-02aa-7b512bdd0241
05/11/2019
medium

Series.PlotOrder property (Excel)

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 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 on Chart1 appear third in the plot order. The example should be run on a 2D column chart that contains three or more series.

Charts("Chart1").ChartGroups(1).SeriesCollection(2).PlotOrder = 3

[!includeSupport and feedback]