Chart Interface

Represents an embedded chart in Office projects for Microsoft Office Excel.

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

Syntax

'Declaration
<GuidAttribute("c4435b63-6e69-4360-92fb-2b144fd9b1d2")> _
Public Interface Chart _
    Inherits IBindableComponent, IComponent, IDisposable, ISupportInitialize

[GuidAttribute("c4435b63-6e69-4360-92fb-2b144fd9b1d2")]
public interface Chart : IBindableComponent, IComponent, 
    IDisposable, ISupportInitialize

The Chart type exposes the following members.

Properties

	Name	Description
	_CodeName	Infrastructure.
	Application	Gets an Application that represents the Microsoft Office Excel application.
	Area3DGroup	Gets a ChartGroup object that represents the area chart group on a 3-D chart.
	AutoScaling	Scales a 3-D chart so that it is closer in size to the equivalent 2-D chart.
	BackWall	Gets an object that represents the back wall of a 3-D chart.
	Bar3DGroup	Gets a ChartGroup object that represents the bar chart group on a 3-D chart.
	BarShape	Gets or sets the shape used with the 3-D bar or column chart.
	BindingContext	Gets or sets the collection of currency managers for the IBindableComponent. (Inherited from IBindableComponent.)
	ChartArea	Gets a ChartArea object that represents the complete chart area for the chart.
	ChartStyle	Gets or sets the style of the chart.
	ChartTitle	Gets a ChartTitle object that represents the title of the specified chart.
	ChartType	Gets or sets the chart type.
	CodeName	Infrastructure.
	Column3DGroup	Gets a ChartGroup object that represents the column chart group on a 3-D chart.
	Container	Infrastructure.
	Corners	Gets a Corners object that represents the corners of a 3-D chart.
	Creator	Gets the application in which this Chart was created.
	DataBindings	Gets the collection of data-binding objects for this IBindableComponent. (Inherited from IBindableComponent.)
	DataTable	Gets a DataTable that represents the chart data table.
	DefaultDataSourceUpdateMode	Gets or sets the default DataSourceUpdateMode.
	DepthPercent	Gets or sets the depth of a 3-D chart as a percentage of the chart width (between 20 and 2000 percent).
	DisplayBlanksAs	Gets or sets the way that blank cells are plotted on a chart.
	Dummy24
	Dummy25
	Elevation	Gets or sets the elevation of the 3-D chart view, in degrees.
	Floor	Gets a Floor object that represents the floor of the 3-D chart.
	GapDepth	Gets or sets the distance between the data series in a 3-D chart, as a percentage of the marker width.
	HasAxis	Gets or sets a value indicating whether a specific axis exists on the Chart control.
	HasDataTable	Gets or sets a value that indicates whether the Chart control has a data table.
	HasLegend	Gets or sets a value that indicates whether the Chart control has a legend.
	HasPivotFields	Gets or sets a value that indicates whether the PivotChart controls are displayed on the specified PivotChart report.
	HasTitle	Gets or sets a value that indicates whether the Chart control has a title.
	HeightPercent	Gets or sets the height of a 3-D chart as a percentage of the Chart control width.
	Hyperlinks	Gets a Hyperlinks collection that represents the hyperlinks for the range or worksheet.
	Index	Infrastructure.
	InnerObject	Gets a Chart that represents the underlying native object for the Chart.
	Legend	Gets a Legend object that represents the legend for the chart.
	Line3DGroup	Gets a ChartGroup object that represents the line chart group on a 3-D chart.
	MailEnvelope	Represents an e-mail header for a document.
	Name	Gets the name of the Chart control.
	OnDoubleClick	Infrastructure.
	OnSheetActivate	Infrastructure.
	OnSheetDeactivate	Infrastructure.
	PageSetup	Gets a PageSetup that contains all the page setup settings for the specified object.
	Parent	Gets the parent object for the Chart control.
	Perspective	Gets or sets the perspective for the 3-D chart view.
	Pie3DGroup	Gets a ChartGroup object that represents the pie chart group on a 3-D chart.
	PivotLayout	Gets a PivotLayout object that represents the placement of fields in a PivotTable report and the placement of axes in a PivotChart report.
	PlotArea	Gets a PlotArea object that represents the plot area of a chart.
	PlotBy	Gets or sets the way columns or rows are used as data series on the chart.
	PlotVisibleOnly	Gets or sets a value that indicates whether only visible cells are plotted.
	PrintedCommentPages	Gets the number of comment pages that will be printed for the current chart.
	ProtectContents	Infrastructure.
	ProtectData	Gets or sets a value that indicates whether modification of series formulas is prevented.
	ProtectDrawingObjects	Infrastructure.
	ProtectFormatting	Gets or sets a value that indicates whether modification of Chart control formatting is prevented.
	ProtectGoalSeek	Gets or sets a value that indicates whether modification of Chart control data points with mouse actions is prevented.
	ProtectionMode	Infrastructure.
	ProtectSelection	Gets or sets a value that indicates whether selection of Chart control elements is prevented.
	RightAngleAxes	Gets or sets a value that indicates whether the Chart control axes are at right angles, independent of chart rotation or elevation.
	Rotation	Gets or sets the rotation of the 3-D chart view (the rotation of the plot area around the z-axis, in degrees).
	Scripts	Gets the Scripts collection, which contains Script objects representing blocks of script or code in the specified document when it is saved as a Web page.
	Shapes	Gets a Shapes object that represents all the shapes on the Chart control.
	ShowAllFieldButtons	Gets or sets whether to display all field buttons on a PivotChart.
	ShowAxisFieldButtons	Gets or sets whether to display axis field buttons on a PivotChart.
	ShowDataLabelsOverMaximum	Gets or sets a value that indicates whether to show the data labels when the value is greater than the maximum value on the value axis.
	ShowLegendFieldButtons	Gets or sets whether to display legend field buttons on a PivotChart.
	ShowReportFilterFieldButtons	Gets or sets whether to display the report filter field buttons on a PivotChart.
	ShowValueFieldButtons	Gets or sets whether to display the value field buttons on a PivotChart.
	ShowWindow	Gets or sets a value that indicates if the embedded chart is displayed in a separate window.
	SideWall	Gets an object that represents the side wall of a 3-D chart.
	Site	Gets or sets the ISite associated with the IComponent. (Inherited from IComponent.)
	SizeWithWindow	Gets or sets the value that indicates whether Microsoft Office Excel resizes the Chart control to match the size of the chart sheet window
	SubType	Infrastructure.
	SurfaceGroup	Gets a ChartGroup object that represents the surface chart group of a 3-D chart.
	Tab	Gets a Tab object for a Chart control.
	Tag	Gets or sets the object that contains data about the Tag control.
	Type	Infrastructure.
	Walls	Gets a Walls object that represents the walls of the 3-D chart.
	WallsAndGridlines2D	Gets or sets a value that indicates whether gridlines are drawn two-dimensionally on a 3-D chart.

Top

Methods

	Name	Description
	_ApplyDataLabels	Infrastructure.
	_Dummy23	Infrastructure.
	_Evaluate	Infrastructure.
	_PrintOut	Infrastructure.
	_Protect	Infrastructure.
	_SaveAs	Infrastructure.
	Activate	Makes the current Chart control the active chart.
	ApplyChartTemplate	Applies a standard or custom chart template to the chart.
	ApplyCustomType	Applies a standard or custom chart type to a Chart control.
	ApplyDataLabels	Applies data labels to a point, a series, or all the series in a Chart control.
	ApplyLayout	Applies the layouts shown on the Ribbon.
	Arcs	Infrastructure.
	AreaGroups	On a 2-D chart, gets an object that represents either a single area chart group (a ChartGroup object) or a collection of the area chart groups (a ChartGroups collection).
	AutoFormat	Infrastructure.
	Axes	Gets an object that represents either a single axis or a collection of the axes on the chart.
	BarGroups	On a 2-D chart, returns an object that represents either a single bar chart group (a ChartGroup object) or a collection of the bar chart groups (a ChartGroups collection).
	BeginInit	Signals the object that initialization is starting. (Inherited from ISupportInitialize.)
	Buttons	Infrastructure.
	ChartGroups	Gets either a single chart group (a ChartGroup object) or a collection of all the chart groups in the chart (a ChartGroups object).
	ChartObjects	Gets an object that represents either a single embedded chart (a ChartObject object) or a collection of all the embedded charts (a ChartObjects object) on the sheet.
	ChartWizard	Modifies the properties of the given Chart control. You can use this method to quickly format a Chart control without setting all the individual properties. This method is non-interactive, and it changes only the specified properties.
	CheckBoxes	Infrastructure.
	CheckSpelling	Checks the spelling of an object. Microsoft Office Excel displays the Spelling dialog box
	ClearToMatchStyle	Clears the chart elements formatting to automatic.
	ColumnGroups	On a 2-D chart, returns an object that represents either a single column chart group (a ChartGroup object) or a collection of the column chart groups (a ChartGroups collection).
	Copy	Infrastructure.
	CopyChartBuild	Infrastructure.
	CopyPicture	Copies the chart to the Clipboard as a picture.
	CreatePublisher	Infrastructure.
	Delete	Deletes a dynamically created Chart control from the worksheet and removes it from the ControlCollection.
	Deselect	Cancels the selection for the specified Chart control.
	Dispose	Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources. (Inherited from IDisposable.)
	DoughnutGroups	On a 2-D chart, returns an object that represents either a single doughnut chart group (a ChartGroup object) or a collection of the doughnut chart groups (a ChartGroups collection).
	DrawingObjects	Infrastructure.
	Drawings	Infrastructure.
	DropDowns	Infrastructure.
	EndInit	Signals the object that initialization is complete. (Inherited from ISupportInitialize.)
	Evaluate	Converts a Microsoft Office Excel name to an object or a value.
	Export	Exports the chart in a graphic format.
	ExportAsFixedFormat	Saves the chart in either PDF or XPS format.
	get_HasAxis	Infrastructure.
	GetChartElement	Gets information about the chart element at specified X and Y coordinates.
	GroupBoxes	Infrastructure.
	GroupObjects	Infrastructure.
	Labels	Infrastructure.
	LineGroups	On a 2-D chart, returns either a single line chart group (a ChartGroup object) or a collection of the line chart groups (a ChartGroups collection).
	Lines	Infrastructure.
	ListBoxes	Infrastructure.
	Location	Moves the Chart control to a new location.
	Move	Infrastructure.
	OptionButtons	Infrastructure.
	Ovals	Infrastructure.
	Paste	Pastes chart data from the Clipboard into the specified Chart control.
	Pictures	Infrastructure.
	PieGroups	On a 2-D chart, returns an object that represents either a single pie chart group (a ChartGroup object) or a collection of the pie chart groups (a ChartGroups collection).
	PrintOut	Prints the Chart control.
	PrintOutEx	Prints the chart.
	PrintPreview	Shows a preview of the Chart control as it would look when printed.
	RadarGroups	On a 2-D chart, returns an object that represents either a single radar chart group (a ChartGroup object) or a collection of the radar chart groups (a ChartGroups collection).
	Rectangles	Infrastructure.
	Refresh	Updates the cache of the Chart or PivotTable object.
	SaveChartTemplate	Saves the current chart as a custom template in the list of available chart templates.
	ScrollBars	Infrastructure.
	SeriesCollection	Gets either a single series (a Series object) or a collection of all the series (a SeriesCollection collection) in the chart or chart group.
	set_HasAxis	Infrastructure.
	SetBackgroundPicture	Sets the background graphic for Chart control.
	SetDefaultChart	Specifies the name of the chart template that Microsoft Office Excel uses when it creates new charts.
	SetElement	Modifies an element on the chart.
	SetSourceData	Sets the source data range for the Chart control.
	Spinners	Infrastructure.
	TextBoxes	Infrastructure.
	XYGroups	On a 2-D chart, returns an object that represents either a single scatter chart group (a ChartGroup object) or a collection of the scatter chart groups (a ChartGroups collection).

Top

Events

	Name	Description
	ActivateEvent	Occurs when the Chart control is activated.
	BeforeDoubleClick	Occurs when the Chart control is double-clicked, before the default double-click action.
	BeforeRightClick	Occurs when the Chart control is right-clicked, before the default right-click action.
	BindingContextChanged	Infrastructure.
	Calculate	Occurs after the Chart control plots new or changed data.
	Deactivate	Occurs when the selection moves away from the Chart control, causing the Chart control to become deactivated.
	Disposed	Represents the method that handles the Disposed event of a component. (Inherited from IComponent.)
	DragOver	Occurs when a range of cells is dragged over a Chart control.
	DragPlot	Occurs when a range of cells is dragged and dropped on the Chart control.
	MouseDown	Occurs when a mouse button is pressed when the pointer is over a Chart control.
	MouseMove	Occurs when the position of the mouse pointer changes over the Chart control.
	MouseUp	Occurs when a mouse button is released when the pointer is over the Chart control.
	Resize	Occurs when the size of the Chart control is changed.
	SelectEvent	Occurs when the Chart control is selected.
	SeriesChange	Occurs when the value of a Chart control data point is changed.

Top

Remarks

Chart controls provide all the features of native Chart objects in the Excel object model. However, Chart controls also expose events. For more information, see Chart Control.

Usage

This documentation describes the version of this type that is used in Office projects that target the .NET Framework 4 and the .NET Framework 4.5. In projects that target the .NET Framework 3.5, this type might have different members and the code examples provided for this type might not work. For documentation about this type in projects that target the .NET Framework 3.5, see the following reference section in the Visual Studio 2008 documentation: https://go.microsoft.com/fwlink/?LinkId=160658.

See Also

Reference

Microsoft.Office.Tools.Excel Namespace

Other Resources

Chart Control

How to: Add Chart Controls to Worksheets

Host Items and Host Controls Overview