SetSourceData Method

Sets the source data range for the chart.

Syntax

Visual Basic

'Declaration
 
Public Sub SetSourceData( _
   ByVal dataRange As String, _
   Optional ByVal plotByRows As Boolean, _
   Optional ByVal cellReferenceMode As Nullable(Of CellReferenceMode) _
) 

C#

public void SetSourceData( 
   string dataRange,
   bool plotByRows,
   Nullable<CellReferenceMode> cellReferenceMode
)

Parameters

dataRange

The data range for the chart

plotByRows

Optional. True to plot by rows where each row is a separate series or false to plot by columns where each column is a separate series. The default is false.

cellReferenceMode

Optional. Determines how to parse the dataRange.

Remarks

For combo charts, this method always displays the first series in a clustered column chart, with all subsequent series displayed in line charts. Use the SetComboChartSourceData to customize the series charts for a combo chart.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2