Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Office and SharePoint development
Office client development
Office 2010
Excel 2010
Excel 2010 Primary Interop Assembly Reference
Class Library
Microsoft.Office.Interop.Excel Namespace
_Chart Interface
_Chart Methods
_ApplyDataLabels Method
_Dummy23 Method
_Evaluate Method
_PrintOut Method
_Protect Method
_SaveAs Method
Activate Method
ApplyChartTemplate Method
ApplyCustomType Method
ApplyDataLabels Method
ApplyLayout Method
Arcs Method
AreaGroups Method
AutoFormat Method
Axes Method
BarGroups Method
Buttons Method
ChartGroups Method
ChartObjects Method
ChartWizard Method
CheckBoxes Method
CheckSpelling Method
ClearToMatchStyle Method
ColumnGroups Method
Copy Method
CopyChartBuild Method
CopyPicture Method
CreatePublisher Method
Delete Method
Deselect Method
DoughnutGroups Method
DrawingObjects Method
Drawings Method
DropDowns Method
Evaluate Method
Export Method
ExportAsFixedFormat Method
GetChartElement Method
GroupBoxes Method
GroupObjects Method
Labels Method
LineGroups Method
Lines Method
ListBoxes Method
Location Method
Move Method
OLEObjects Method
OptionButtons Method
Ovals Method
Paste Method
Pictures Method
PieGroups Method
PrintOut Method
PrintOutEx Method
PrintPreview Method
Protect Method
RadarGroups Method
Rectangles Method
Refresh Method
SaveAs Method
SaveChartTemplate Method
ScrollBars Method
Select Method
SeriesCollection Method
SetBackgroundPicture Method
SetDefaultChart Method
SetElement Method
SetSourceData Method
Spinners Method
TextBoxes Method
Unprotect Method
XYGroups Method
Expand Minimize
0 out of 4 rated this helpful - Rate this topic

_Chart.SetSourceData Method

Office 2010

Sets the source data range for the chart.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
C#
VB
Copy 
void SetSourceData(
	Range Source,
	Object PlotBy
)

Parameters

Source
Type: Microsoft.Office.Interop.Excel.Range
Required Range. The range that contains the source data.
PlotBy
Type: System.Object
Optional Object. Specifies the way the data is to be plotted. Can be either of the following XlRowCol constants: xlColumns or xlRows.
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.