Chart.PlotBy Property

Syntax

expression.PlotBy

expression A variable that represents a Chart object.

Remarks

For PivotChart reports, this property is read-only and always returns xlColumns.

Example

This example causes the embedded chart to plot data by columns.

Visual Basic for Applications
`Worksheets(1).ChartObjects(1).Chart.PlotBy = xlColumns`

change chart columns data series change chart plot by rows determine columns or rows data series chart plot by Plot By Property PlotBy plotby property

Returns or sets the way columns or rows are used as data series on the chart. Can be one of the following XlRowCol constants: xlColumns or xlRows. Read/write Long.

See also: