SetComboChartSourceData Method

'Declaration
 
Public Sub SetComboChartSourceData( _
   ByVal dataRange As System.String, _
   ByVal seriesChartTypes() As ChartType, _
   Optional ByVal plotByRows As System.Boolean, _
   Optional ByVal cellReferenceMode As System.Nullable(Of CellReferenceMode) _
) 

public void SetComboChartSourceData( 
   System.string dataRange,
   ChartType[] seriesChartTypes,
   System.bool plotByRows,
   System.Nullable<CellReferenceMode> cellReferenceMode
)

Parameters

dataRange

The data range for the combo chart

seriesChartTypes

An array of ChartType constants which specify the chart type for each series yielded from the specified dataRange.

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.

Combo charts support multiple chart types within the main chart, with each different chart type being associated with one or more Infragistics.Documents.Excel.Charts.Series.

Use this method to populate the SeriesCollection for a combo chart.

For example, given a dataRange which yields three series, the caller can specify an array with three elements as the value of the seriesChartTypes parameter. Each array element is then applied to the corresponding series, in the same order in which they appear in the array.

Duplicate ChartType values can appear in the seriesChartTypes array, in which case the corresponding series appear within the same chart. For example, specifying an array with ClusteredColumn, Line, and Line results in a combo chart with the first series appearing in a clustered column chart, and the remaining series appearing in a line chart.

Specifying null for the value of the seriesChartTypes parameter is treated the same as a two-element array containing 'ColumnClustered' and 'Line', resulting in a clustered column chart for the first series, and a line chart for the remaining series.

If fewer values are present in the seriesChartTypes array than the number of series yielded from the specified dataRange, the remaining series acquire the same ChartType and AxisGroup as the last element in the seriesChartTypes array. If more values are present in the array than the number of series yielded, these values are ignored.

Certain chart type values are invalid for a combo chart; if any of these chart types are present in the array, an exception is thrown, listing the invalid chart types.

The following table lists the ChartType values which are supported in combo charts, grouped by series type: