Chart.SetSourceData(Range, Object) Method

Reference

Definition

Namespace:: Microsoft.Office.Tools.Excel

Assembly:: Microsoft.Office.Tools.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Sets the source data range for the Chart control.

public void SetSourceData (Microsoft.Office.Interop.Excel.Range Source, object PlotBy);

abstract member SetSourceData : Microsoft.Office.Interop.Excel.Range * obj -> unit

Public Sub SetSourceData (Source As Range, Optional PlotBy As Object)

Parameters

Source: Range

Range. The range that contains the source data.

PlotBy: Object

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

Examples

The following code example creates a Chart and then uses the SetSourceData method to set the data source of the chart to a range that contains cells A1 through B5.

private void ApplyDataSource()
{
    this.Range["A1", "A5"].Value2 = 22;
    this.Range["B1", "B5"].Value2 = 55;

    Microsoft.Office.Tools.Excel.Chart chart1 =
        this.Controls.AddChart(this.Range["D2", "H12"], 
        "chart1");

    chart1.SetSourceData(this.Range["A1", "B5"], 
        Excel.XlRowCol.xlColumns);
    chart1.ChartType = Excel.XlChartType.xl3DColumn;
}

Private Sub ApplyDataSource()
    Me.Range("A1", "A5").Value2 = 22
    Me.Range("B1", "B5").Value2 = 55

    Dim Chart1 As Microsoft.Office.Tools.Excel.Chart = _
    Me.Controls.AddChart(Me.Range("D2", "H12"), "Chart1")

    Chart1.SetSourceData(Me.Range("A1", "B5"), Excel.XlRowCol.xlColumns)
    Chart1.ChartType = Excel.XlChartType.xl3DColumn
End Sub

Remarks

Optional Parameters

For information on optional parameters, see Optional Parameters in Office Solutions.

Applies to