Excel.Chart.PlotBy.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Chart.PlotBy property (Excel)	vbaxl10.chm149155	vbaxl10.chm149155	Excel.Chart.PlotBy	69ff0fbe-7954-6808-68fa-cc92b2851dd8	04/16/2019	medium

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

[!includeSupport and feedback]