Share via


ChartSheetBase.SetSourceData Method

Sets the source data range for the Microsoft.Office.Tools.Excel.ChartSheetBase.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)

Syntax

'Declaration
Public Sub SetSourceData ( _
    source As Range, _
    plotBy As Object _
)
public void SetSourceData(
    Range source,
    Object plotBy
)

Parameters

Remarks

Optional Parameters

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

Examples

The following code example uses the SetSourceData method to set the data source of the current Microsoft.Office.Tools.Excel.ChartSheetBase to a range on Sheet1 that contains cells A1 through B5.

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
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;
}

.NET Framework Security

See Also

Reference

ChartSheetBase Class

Microsoft.Office.Tools.Excel Namespace