_Chart.SetSourceData Method

Sets the source data range for the chart.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Sub SetSourceData ( _
    Source As Range, _
    PlotBy As Object _
)
'Usage
Dim instance As _Chart
Dim Source As Range
Dim PlotBy As Object

instance.SetSourceData(Source, PlotBy)

void SetSourceData(
    Range Source,
    Object PlotBy
)

Parameters

• Source
  Type: Microsoft.Office.Interop.Excel.Range

  Required Range. The range that contains the source data.

• PlotBy
  Type: System.Object

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

See Also

Reference

_Chart Interface

_Chart Members

Microsoft.Office.Interop.Excel Namespace