Chart.PlotBy Property (Excel)
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.
Worksheets(1).ChartObjects(1).Chart.PlotBy = xlColumns