Export (0) Print
Expand All
Expand Minimize

ChartSheetBase.SetSourceData Method

[This documentation is for preview only, and is subject to change in later releases. Blank topics are included as placeholders.]

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)

public void SetSourceData(
	Range source,
	Object plotBy
)

Parameters

source
Type: Microsoft.Office.Interop.Excel.Range

The range that contains the source data.

plotBy
Type: System.Object

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

Optional Parameters

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

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

Show:
© 2014 Microsoft