Chart Interface

Definition

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

[System.Runtime.InteropServices.Guid("c4435b63-6e69-4360-92fb-2b144fd9b1d2")]
public interface Chart : IDisposable, System.ComponentModel.IComponent, System.ComponentModel.ISupportInitialize, System.Windows.Forms.IBindableComponent
Attributes
Implements

Remarks

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.

Note

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

Properties

Application

Gets an Application that represents the Microsoft Office Excel application.

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.

BarShape

Gets or sets the shape used with the 3-D bar or column chart.

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.

Container
Creator

Gets the application in which this Chart was created.

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.

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.

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.

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.

MailEnvelope

Represents an e-mail header for a document.

Name

Gets the name of the Chart control.

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.

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.

ProtectData

Gets or sets a value that indicates whether modification of series formulas is prevented.

ProtectFormatting

Gets or sets a value that indicates whether modification of Chart control formatting is prevented.

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

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.

SideWall

Gets an object that represents the side wall 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.

Walls

Gets a Walls object that represents the walls of the 3-D chart.

Methods

Activate()

Makes the current Chart control the active chart.

ApplyChartTemplate(String)

Applies a standard or custom chart template to the chart.

ApplyDataLabels(XlDataLabelsType, Object, Object, Object, Object, Object, Object, Object, Object, Object)

Applies data labels to a point, a series, or all the series in a Chart control.

ApplyLayout(Int32, Object)

Applies the layouts shown on the Ribbon.

Axes(Object, XlAxisGroup)

Gets an object that represents either a single axis or a collection of the axes on the chart.

ChartGroups(Object)

Gets either a single chart group (a ChartGroup object) or a collection of all the chart groups in the chart (a ChartGroups object).

ChartObjects(Object)

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(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object)

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.

CheckSpelling(Object, Object, Object, Object)

Checks the spelling of an object. Microsoft Office Excel displays the Spelling dialog box

ClearToMatchStyle()

Clears the chart elements formatting to automatic.

Copy(Object, Object)
CopyPicture(XlPictureAppearance, XlCopyPictureFormat, XlPictureAppearance)

Copies the chart to the Clipboard as a picture.

Delete()

Deletes a dynamically created Chart control from the worksheet and removes it from the ControlCollection.

Evaluate(Object)

Converts a Microsoft Office Excel name to an object or a value.

Export(String, Object, Object)

Exports the chart in a graphic format.

ExportAsFixedFormat(XlFixedFormatType, Object, Object, Object, Object, Object, Object, Object, Object)

Saves the chart in either PDF or XPS format.

GetChartElement(Int32, Int32, Int32, Int32, Int32)

Gets information about the chart element at specified X and Y coordinates.

Location(XlChartLocation, Object)

Moves the Chart control to a new location.

Move(Object, Object)
Paste(Object)

Pastes chart data from the Clipboard into the specified Chart control.

PrintOutEx(Object, Object, Object, Object, Object, Object, Object, Object)

Prints the chart.

PrintPreview(Object)

Shows a preview of the Chart control as it would look when printed.

Refresh()

Updates the cache of the Chart or PivotTable object.

SaveChartTemplate(String)

Saves the current chart as a custom template in the list of available chart templates.

SeriesCollection(Object)

Gets either a single series (a Series object) or a collection of all the series (a SeriesCollection collection) in the chart or chart group.

SetBackgroundPicture(String)

Sets the background graphic for Chart control.

SetDefaultChart(Object)

Specifies the name of the chart template that Microsoft Office Excel uses when it creates new charts.

SetElement(MsoChartElementType)

Modifies an element on the chart.

SetSourceData(Range, Object)

Sets the source data range for the Chart control.

Events

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

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.

Applies to