ChartSheet.SetSourceData Method

Article
01/07/2014

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

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

Syntax

'Declaration
Sub SetSourceData ( _
    Source As Range, _
    PlotBy As Object _
)

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.

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.ChartSheet 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

Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.

Partager via