ChartSheetBase.SetSourceData(Range, Object) Method
Definition
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 ChartSheetBase.
public void SetSourceData (Microsoft.Office.Interop.Excel.Range source, object plotBy);member this.SetSourceData : Microsoft.Office.Interop.Excel.Range * obj -> unitPublic 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.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;
}
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.