SetSourceData Method

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

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.

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.

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, 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

Reference

WorksheetChart Class
WorksheetChart Members