Version

SetSourceData Method

Sets the source data range for the chart.
Syntax
'Declaration
 
Public Sub SetSourceData( _
   ByVal dataRange As System.String, _
   Optional ByVal plotByRows As System.Boolean, _
   Optional ByVal cellReferenceMode As System.Nullable(Of CellReferenceMode) _
) 
public void SetSourceData( 
   System.string dataRange,
   System.bool plotByRows,
   System.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 8.1, 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

See Also

View on GitHub