Export (0) Print
Expand All

Chart.SetSourceData Method (Excel)

Sets the source data range for the chart.

expression .SetSourceData(Source, PlotBy)

expression A variable that represents a Chart object.

Parameters

Name

Required/Optional

Data Type

Description

Source

Required

Range

The range that contains the source data.

PlotBy

Optional

Variant

Specifies the way the data is to be plotted. Can be either of the following XlRowCol constants: xlColumns or xlRows.

This example sets the source data range for chart one.

Charts(1).SetSourceData Source:=Sheets(1).Range("a1:a10"), _ 
 PlotBy:=xlColumns
Show:
© 2014 Microsoft