Chart Interface

[This documentation is for preview only, and is subject to change in later releases. Blank topics are included as placeholders.]

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)

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

The Chart type exposes the following members.

  NameDescription
Public property_CodeNameInfrastructure.
Public propertyApplicationGets an Application that represents the Microsoft Office Excel application.
Public propertyArea3DGroupGets a ChartGroup object that represents the area chart group on a 3-D chart.
Public propertyAutoScalingScales a 3-D chart so that it is closer in size to the equivalent 2-D chart.
Public propertyBackWallGets an object that represents the back wall of a 3-D chart.
Public propertyBar3DGroupGets a ChartGroup object that represents the bar chart group on a 3-D chart.
Public propertyBarShapeGets or sets the shape used with the 3-D bar or column chart.
Public propertyBindingContextGets or sets the collection of currency managers for the IBindableComponent. (Inherited from IBindableComponent.)
Public propertyChartAreaGets a ChartArea object that represents the complete chart area for the chart.
Public propertyChartStyleGets or sets the style of the chart.
Public propertyChartTitleGets a ChartTitle object that represents the title of the specified chart.
Public propertyChartTypeGets or sets the chart type.
Public propertyCodeNameInfrastructure.
Public propertyColumn3DGroupGets a ChartGroup object that represents the column chart group on a 3-D chart.
Public propertyContainerInfrastructure.
Public propertyCornersGets a Corners object that represents the corners of a 3-D chart.
Public propertyCreatorGets the application in which this Chart was created.
Public propertyDataBindingsGets the collection of data-binding objects for this IBindableComponent. (Inherited from IBindableComponent.)
Public propertyDataTableGets a DataTable that represents the chart data table.
Public propertyDefaultDataSourceUpdateModeGets or sets the default DataSourceUpdateMode.
Public propertyDepthPercentGets or sets the depth of a 3-D chart as a percentage of the chart width (between 20 and 2000 percent).
Public propertyDisplayBlanksAsGets or sets the way that blank cells are plotted on a chart.
Public propertyDummy24
Public propertyDummy25
Public propertyElevationGets or sets the elevation of the 3-D chart view, in degrees.
Public propertyFloorGets a Floor object that represents the floor of the 3-D chart.
Public propertyGapDepthGets or sets the distance between the data series in a 3-D chart, as a percentage of the marker width.
Public propertyHasAxisGets or sets a value indicating whether a specific axis exists on the Chart control.
Public propertyHasDataTableGets or sets a value that indicates whether the Chart control has a data table.
Public propertyHasLegendGets or sets a value that indicates whether the Chart control has a legend.
Public propertyHasPivotFieldsGets or sets a value that indicates whether the PivotChart controls are displayed on the specified PivotChart report.
Public propertyHasTitleGets or sets a value that indicates whether the Chart control has a title.
Public propertyHeightPercentGets or sets the height of a 3-D chart as a percentage of the Chart control width.
Public propertyHyperlinksGets a Hyperlinks collection that represents the hyperlinks for the range or worksheet.
Public propertyIndexInfrastructure.
Public propertyInnerObjectGets a Microsoft.Office.Interop.Excel.Chart that represents the underlying native object for the Chart.
Public propertyLegendGets a Legend object that represents the legend for the chart.
Public propertyLine3DGroupGets a ChartGroup object that represents the line chart group on a 3-D chart.
Public propertyMailEnvelopeRepresents an e-mail header for a document.
Public propertyNameGets the name of the Chart control.
Public propertyOnDoubleClickInfrastructure.
Public propertyOnSheetActivateInfrastructure.
Public propertyOnSheetDeactivateInfrastructure.
Public propertyPageSetupGets a PageSetup that contains all the page setup settings for the specified object.
Public propertyParentGets the parent object for the Chart control.
Public propertyPerspectiveGets or sets the perspective for the 3-D chart view.
Public propertyPie3DGroupGets a ChartGroup object that represents the pie chart group on a 3-D chart.
Public propertyPivotLayoutGets a PivotLayout object that represents the placement of fields in a PivotTable report and the placement of axes in a PivotChart report.
Public propertyPlotAreaGets a PlotArea object that represents the plot area of a chart.
Public propertyPlotByGets or sets the way columns or rows are used as data series on the chart.
Public propertyPlotVisibleOnlyGets or sets a value that indicates whether only visible cells are plotted.
Public propertyPrintedCommentPagesGets the number of comment pages that will be printed for the current chart.
Public propertyProtectContentsInfrastructure.
Public propertyProtectDataGets or sets a value that indicates whether modification of series formulas is prevented.
Public propertyProtectDrawingObjectsInfrastructure.
Public propertyProtectFormattingGets or sets a value that indicates whether modification of Chart control formatting is prevented.
Public propertyProtectGoalSeekGets or sets a value that indicates whether modification of Chart control data points with mouse actions is prevented.
Public propertyProtectionModeInfrastructure.
Public propertyProtectSelectionGets or sets a value that indicates whether selection of Chart control elements is prevented.
Public propertyRightAngleAxesGets or sets a value that indicates whether the Chart control axes are at right angles, independent of chart rotation or elevation.
Public propertyRotationGets or sets the rotation of the 3-D chart view (the rotation of the plot area around the z-axis, in degrees).
Public propertyScriptsGets 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.
Public propertyShapesGets a Shapes object that represents all the shapes on the Chart control.
Public propertyShowAllFieldButtonsGets or sets whether to display all field buttons on a PivotChart.
Public propertyShowAxisFieldButtonsGets or sets whether to display axis field buttons on a PivotChart.
Public propertyShowDataLabelsOverMaximumGets 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.
Public propertyShowLegendFieldButtonsGets or sets whether to display legend field buttons on a PivotChart.
Public propertyShowReportFilterFieldButtonsGets or sets whether to display the report filter field buttons on a PivotChart.
Public propertyShowValueFieldButtonsGets or sets whether to display the value field buttons on a PivotChart.
Public propertyShowWindowGets or sets a value that indicates if the embedded chart is displayed in a separate window.
Public propertySideWallGets an object that represents the side wall of a 3-D chart.
Public propertySiteGets or sets the ISite associated with the IComponent. (Inherited from IComponent.)
Public propertySizeWithWindowGets or sets the value that indicates whether Microsoft Office Excel resizes the Chart control to match the size of the chart sheet window
Public propertySubTypeInfrastructure.
Public propertySurfaceGroupGets a ChartGroup object that represents the surface chart group of a 3-D chart.
Public propertyTabGets a Tab object for a Chart control.
Public propertyTagGets or sets the object that contains data about the Tag control.
Public propertyTypeInfrastructure.
Public propertyWallsGets a Walls object that represents the walls of the 3-D chart.
Public propertyWallsAndGridlines2DGets or sets a value that indicates whether gridlines are drawn two-dimensionally on a 3-D chart.
Top

  NameDescription
Public method_ApplyDataLabelsInfrastructure.
Public method_Dummy23Infrastructure.
Public method_EvaluateInfrastructure.
Public method_PrintOutInfrastructure.
Public method_ProtectInfrastructure.
Public method_SaveAsInfrastructure.
Public methodActivateMakes the current Chart control the active chart.
Public methodApplyChartTemplateApplies a standard or custom chart template to the chart.
Public methodApplyCustomTypeApplies a standard or custom chart type to a Chart control.
Public methodApplyDataLabelsApplies data labels to a point, a series, or all the series in a Chart control.
Public methodApplyLayoutApplies the layouts shown on the Ribbon.
Public methodArcsInfrastructure.
Public methodAreaGroupsOn 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).
Public methodAutoFormatInfrastructure.
Public methodAxesGets an object that represents either a single axis or a collection of the axes on the chart.
Public methodBarGroupsOn 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).
Public methodBeginInitSignals the object that initialization is starting. (Inherited from ISupportInitialize.)
Public methodButtonsInfrastructure.
Public methodChartGroupsGets either a single chart group (a ChartGroup object) or a collection of all the chart groups in the chart (a ChartGroups object).
Public methodChartObjectsGets 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.
Public methodChartWizardModifies 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.
Public methodCheckBoxesInfrastructure.
Public methodCheckSpellingChecks the spelling of an object. Microsoft Office Excel displays the Spelling dialog box
Public methodClearToMatchStyleClears the chart elements formatting to automatic.
Public methodColumnGroupsOn 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).
Public methodCopyInfrastructure.
Public methodCopyChartBuildInfrastructure.
Public methodCopyPictureCopies the chart to the Clipboard as a picture.
Public methodCreatePublisherInfrastructure.
Public methodDeleteDeletes a dynamically created Chart control from the worksheet and removes it from the ControlCollection.
Public methodDeselectCancels the selection for the specified Chart control.
Public methodDisposePerforms application-defined tasks associated with freeing, releasing, or resetting unmanaged resources. (Inherited from IDisposable.)
Public methodDoughnutGroupsOn 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).
Public methodDrawingObjectsInfrastructure.
Public methodDrawingsInfrastructure.
Public methodDropDownsInfrastructure.
Public methodEndInitSignals the object that initialization is complete. (Inherited from ISupportInitialize.)
Public methodEvaluateConverts a Microsoft Office Excel name to an object or a value.
Public methodExportExports the chart in a graphic format.
Public methodExportAsFixedFormatSaves the chart in either PDF or XPS format.
Public methodget_HasAxisInfrastructure.
Public methodGetChartElementGets information about the chart element at specified X and Y coordinates.
Public methodGroupBoxesInfrastructure.
Public methodGroupObjectsInfrastructure.
Public methodLabelsInfrastructure.
Public methodLineGroupsOn 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).
Public methodLinesInfrastructure.
Public methodListBoxesInfrastructure.
Public methodLocationMoves the Chart control to a new location.
Public methodMoveInfrastructure.
Public methodOptionButtonsInfrastructure.
Public methodOvalsInfrastructure.
Public methodPastePastes chart data from the Clipboard into the specified Chart control.
Public methodPicturesInfrastructure.
Public methodPieGroupsOn 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).
Public methodPrintOutPrints the Chart control.
Public methodPrintOutExPrints the chart.
Public methodPrintPreviewShows a preview of the Chart control as it would look when printed.
Public methodRadarGroupsOn 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).
Public methodRectanglesInfrastructure.
Public methodRefreshUpdates the cache of the Chart or PivotTable object.
Public methodSaveChartTemplateSaves the current chart as a custom template in the list of available chart templates.
Public methodScrollBarsInfrastructure.
Public methodSeriesCollectionGets either a single series (a Series object) or a collection of all the series (a SeriesCollection collection) in the chart or chart group.
Public methodset_HasAxisInfrastructure.
Public methodSetBackgroundPictureSets the background graphic for Chart control.
Public methodSetDefaultChartSpecifies the name of the chart template that Microsoft Office Excel uses when it creates new charts.
Public methodSetElementModifies an element on the chart.
Public methodSetSourceDataSets the source data range for the Chart control.
Public methodSpinnersInfrastructure.
Public methodTextBoxesInfrastructure.
Public methodXYGroupsOn 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

  NameDescription
Public eventActivateEventOccurs when the Chart control is activated.
Public eventBeforeDoubleClickOccurs when the Chart control is double-clicked, before the default double-click action.
Public eventBeforeRightClickOccurs when the Chart control is right-clicked, before the default right-click action.
Public eventBindingContextChangedInfrastructure.
Public eventCalculateOccurs after the Chart control plots new or changed data.
Public eventDeactivateOccurs when the selection moves away from the Chart control, causing the Chart control to become deactivated.
Public eventDisposedRepresents the method that handles the Disposed event of a component. (Inherited from IComponent.)
Public eventDragOverOccurs when a range of cells is dragged over a Chart control.
Public eventDragPlotOccurs when a range of cells is dragged and dropped on the Chart control.
Public eventMouseDownOccurs when a mouse button is pressed when the pointer is over a Chart control.
Public eventMouseMoveOccurs when the position of the mouse pointer changes over the Chart control.
Public eventMouseUpOccurs when a mouse button is released when the pointer is over the Chart control.
Public eventResizeOccurs when the size of the Chart control is changed.
Public eventSelectEventOccurs when the Chart control is selected.
Public eventSeriesChangeOccurs when the value of a Chart control data point is changed.
Top

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

NoteNote

This interface is implemented by the Visual Studio Tools for Office runtime. It is not intended to be implemented in your code. For more information, see Visual Studio Tools for Office Runtime Overview.

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: http://go.microsoft.com/fwlink/?LinkId=160658.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft