Chart.PlotBy Property (Word)

Returns or sets the way columns or rows are used as data series on the chart. Read/write Long.

Version Information

Version Added: Word 2007

Syntax

expression .PlotBy

expression A variable that represents a Chart object.

Remarks

The value of this property can be one of the following XlRowCol constants:

  • xlColumns

  • xlRows

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

Example

The following example causes the first chart in the active document to plot data by columns.

With ActiveDocument.InlineShapes(1) 
 If .HasChart Then 
 .Chart.PlotBy = xlColumns 
 End If 
End With

See Also

Concepts

Chart Object

Chart Object Members