Partager via


ChartSheet.SetSourceData(Range, Object) Method

Definition

Sets the source data range for the ChartSheet.

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

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 uses the SetSourceData method to set the data source of the current Microsoft.Office.Tools.Excel.ChartSheet to a range on Sheet1 that contains cells A1 through B5.

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

    this.SetSourceData(Globals.Sheet1.Range["A1", "B5"],
        Excel.XlRowCol.xlColumns);
    this.ChartType = Excel.XlChartType.xl3DArea;

    this.Area3DGroup.HasDropLines = true;
}
Private Sub UseArea3DGroup()
    Globals.Sheet1.Range("A1", "A5").Value2 = 22
    Globals.Sheet1.Range("B1", "B5").Value2 = 55

    Me.SetSourceData(Globals.Sheet1.Range("A1", "B5"), _
        Excel.XlRowCol.xlColumns)
    Me.ChartType = Excel.XlChartType.xl3DArea
    Me.Area3DGroup.HasDropLines = True
End Sub

Remarks

Optional Parameters

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

Applies to