Share via

Chart.PlotBy Property

  • Article
Excel Developer Reference

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.

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

See Also