United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Development Tools and Languages

Visual Studio 2008

Visual Studio

Visual Studio Tools for Office

Reference

2007 System Managed Reference

Microsoft.Office.Tools.Excel Namespace (2007 System)

Chart Class (2007 System)

Chart Methods (2007 System)

_ApplyDataLabels Method (2007 System)

_Dummy23 Method (2007 System)

_Evaluate Method (2007 System)

_PrintOut Method (2007 System)

_Protect Method (2007 System)

_SaveAs Method (2007 System)

Activate Method (2007 System)

ApplyChartTemplate Method (2007 System)

ApplyCustomType Method (2007 System)

ApplyDataLabels Method (2007 System)

ApplyLayout Method (2007 System)

Arcs Method (2007 System)

AreaGroups Method (2007 System)

AutoFormat Method (2007 System)

Axes Method (2007 System)

BarGroups Method (2007 System)

BeginInit Method (2007 System)

Buttons Method (2007 System)

ChartGroups Method (2007 System)

ChartObjects Method (2007 System)

ChartWizard Method (2007 System)

CheckBoxes Method (2007 System)

CheckSpelling Method (2007 System)

ClearToMatchStyle Method (2007 System)

ColumnGroups Method (2007 System)

Copy Method (2007 System)

CopyChartBuild Method (2007 System)

CopyPicture Method (2007 System)

CreatePublisher Method (2007 System)

Delete Method (2007 System)

Deselect Method (2007 System)

Dispose Method (2007 System)

DoughnutGroups Method (2007 System)

DrawingObjects Method (2007 System)

Drawings Method (2007 System)

DropDowns Method (2007 System)

EndInit Method (2007 System)

Evaluate Method (2007 System)

Export Method (2007 System)

ExportAsFixedFormat Method (2007 System)

get_HasAxis Method (2007 System)

GetChartElement Method (2007 System)

GroupBoxes Method (2007 System)

GroupObjects Method (2007 System)

ISupportInitializeControl.InitializeControl Method (2007 System)

Labels Method (2007 System)

LineGroups Method (2007 System)

Lines Method (2007 System)

ListBoxes Method (2007 System)

Location Method (2007 System)

Move Method (2007 System)

OptionButtons Method (2007 System)

Ovals Method (2007 System)

Paste Method (2007 System)

Pictures Method (2007 System)

PieGroups Method (2007 System)

PrintOut Method (2007 System)

PrintOutEx Method (2007 System)

PrintPreview Method (2007 System)

RadarGroups Method (2007 System)

Rectangles Method (2007 System)

Refresh Method (2007 System)

SaveChartTemplate Method (2007 System)

ScrollBars Method (2007 System)

SeriesCollection Method (2007 System)

set_HasAxis Method (2007 System)

SetBackgroundPicture Method (2007 System)

SetDefaultChart Method (2007 System)

SetElement Method (2007 System)

SetSourceData Method (2007 System)

Spinners Method (2007 System)

TextBoxes Method (2007 System)

XYGroups Method (2007 System)

Minimize

This topic has not yet been rated - Rate this topic

Chart.SetSourceData Method (2007 System)

Visual Studio 2008

Sets the source data range for the Chart control.

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

public void SetSourceData(
	Range Source,
	Object PlotBy
)

Parameters

Source: Type: Range
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 The Variable missing and Optional Parameters in Office Solutions.

The following code example creates a Chart and then uses the SetSourceData method to set the data source of the chart to a range that contains cells A1 through B5.

private void ApplyDataSource()
{
    this.Range["A1", "A5"].Value2 = 22;
    this.Range["B1", "B5"].Value2 = 55;

    Microsoft.Office.Tools.Excel.Chart chart1 =
        this.Controls.AddChart(this.Range["D2", "H12"], 
        "chart1");

    chart1.SetSourceData(this.Range["A1", "B5"], 
        Excel.XlRowCol.xlColumns);
    chart1.ChartType = Excel.XlChartType.xl3DColumn;
}

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

Reference

Microsoft.Office.Tools.Excel Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft. All rights reserved.