_Chart Members

Include Protected Members
Include Inherited Members

Represents a chart in a workbook. The chart can be either an embedded chart (contained in a ChartObject) or a separate chart sheet.

The _Chart type exposes the following members.

Properties

	Name	Description
	_CodeName	Reserved for internal use.
	Application	When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object).
	Area3DGroup	Returns a ChartGroup object that represents the area chart group on a 3-D chart.
	AutoScaling	True if Microsoft Excel scales a 3-D chart so that it's closer in size to the equivalent 2-D chart. The RightAngleAxes property must be True.
	BackWall	Returns a Walls object that allows the user to individually format the back wall of a 3-D chart. Read-only.
	Bar3DGroup	Returns a ChartGroup object that represents the bar chart group on a 3-D chart.
	BarShape	Returns or sets the shape used with the 3-D bar or column chart.
	ChartArea	Returns a ChartArea object that represents the complete chart area for the chart.
	ChartStyle	Returns or sets the chart style for the chart. Read/write.
	ChartTitle	Returns a ChartTitle object that represents the title of the specified chart.
	ChartType	Returns or sets the chart type.
	CodeName	Returns the code name for the object.
	Column3DGroup	Returns a ChartGroup object that represents the column chart group on a 3-D chart.
	Corners	Returns a Corners object that represents the corners of a 3-D chart.
	Creator	Returns a constant in the XlCreator enumeration that indicates the application in which this object was created. If the object was created in Microsoft Excel, this property returns the string XCEL, which is equivalent to the hexadecimal number 5843454C.
	DataTable	Returns a DataTable object that represents the chart data table.
	DepthPercent	Returns or sets the depth of a 3-D chart as a percentage of the chart width (between 20 and 2000 percent).
	DisplayBlanksAs	Returns or sets the way that blank cells are plotted on a chart. Can be one of the following XlDisplayBlanksAs constants: xlNotPlotted, xlInterpolated, or xlZero.
	Elevation	Returns or sets the elevation of the 3-D chart view in degrees.
	Floor	Returns a Floor object that represents the floor of the 3-D chart.
	GapDepth	Returns or sets the distance between the data series in a 3-D chart as a percentage of the marker width. The value of this property must be between 0 and 500.
	HasAxis	Returns or sets which axes exist on the chart.
	HasDataTable	True if the chart has a data table.
	HasLegend	True if the chart has a legend.
	HasPivotFields	True if the PivotChart controls are displayed on the specified PivotChart report. The default value is True. For a regular chart, this property always returns False and cannot be set.
	HasTitle	True if the axis or chart has a visible title.
	HeightPercent	Returns or sets the height of a 3-D chart as a percentage of the chart width (between 5 and 500 percent).
	Hyperlinks	Returns a Hyperlinks collection that represents the hyperlinks for the range or worksheet.
	Index	Returns the index number of the object within the collection of similar objects.
	InDraftMode
	Legend	Returns a Legend object that represents the legend for the chart.
	Line3DGroup	Returns a ChartGroup object that represents the line chart group on a 3-D chart.
	MailEnvelope	Represents an e-mail header for a document.
	Name	Returns or sets the name of the object.
	Next	Returns a Chart object that represents the next sheet or cell.
	OnDoubleClick	Reserved for internal use.
	OnSheetActivate	Reserved for internal use.
	OnSheetDeactivate	Reserved for internal use.
	PageSetup	Returns a PageSetup object that contains all the page setup settings for the specified object.
	Parent	Returns the parent object for the specified object.
	Perspective	Returns or sets the perspective for the 3-D chart view. Must be between 0 and 100. This property is ignored if the RightAngleAxes property is True.
	Pie3DGroup	Returns a ChartGroup object that represents the pie chart group on a 3-D chart.
	PivotLayout	Returns a PivotLayout object that represents the placement of fields in a PivotTable report and the placement of axes in a PivotChart report.
	PlotArea	Returns a PlotArea object that represents the plot area of a chart.
	PlotBy	Returns or sets the way columns or rows are used as data series on the chart. Can be one of the following XlRowCol constants: xlColumns or xlRows. For PivotChart reports, this property is read-only and always returns xlColumns.
	PlotVisibleOnly	True if only visible cells are plotted. False if both visible and hidden cells are plotted.
	Previous	Returns a Chart object that represents the previous sheet or cell.
	PrintedCommentPages	Gets the number of comment pages that will be printed for the current chart.
	ProtectContents	True if the contents of the sheet are protected. This protects the entire chart.
	ProtectData	True if series formulas cannot be modified by the user.
	ProtectDrawingObjects	True if shapes are protected.
	ProtectFormatting	True if chart formatting cannot be modified by the user.
	ProtectGoalSeek	True if the user cannot modify chart data points with mouse actions.
	ProtectionMode	True if user-interface-only protection is turned on. To turn on user interface protection, use the Protect method with the UserInterfaceOnly argument set to True.
	ProtectSelection	True if chart elements cannot be selected.
	RightAngleAxes	True if the chart axes are at right angles, independent of chart rotation or elevation. Applies only to 3-D line, column, and bar charts.
	Rotation	Returns or sets the rotation of the 3-D chart view (the rotation of the plot area around the z-axis in degrees). The value of this property must be from 0 to 360, except for 3-D bar charts, where the value must be from 0 to 44. The default value is 20. Applies only to 3-D charts.
	Scripts	Returns the Scripts collection, which contains Script objects representing blocks of script or code in the specified document when it’s saved as a Web page.
	Shapes	Returns a Shapes object that represents all the shapes on the worksheet or chart sheet. Read-only.
	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	Returns or sets whether to show the data labels when the value is greater than the maximum value on the value axis. Read/write.
	ShowDraftModeButton	Reserved for internal use.
	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	True if the embedded chart is displayed in a separate window. The Chart object used with this property must refer to an embedded chart.
	SideWall	Returns a Walls object that allows the user to individually format the side wall of a 3-D chart. Read-only.
	SizeWithWindow	True if Microsoft Excel resizes the chart to match the size of the chart sheet window. False if the chart size isn't attached to the window size. Applies only to chart sheets (doesn't apply to embedded charts).
	SubType	Reserved for internal use.
	SurfaceGroup	Returns a ChartGroup object that represents the surface chart group of a 3-D chart.
	Tab	Returns a Tab object for a chart or a worksheet.
	Type	Reserved for internal use.
	Visible	Determines whether the object is visible.
	Walls	Returns a Walls object that represents the walls of the 3-D chart.
	WallsAndGridlines2D	True if gridlines are drawn two-dimensionally on a 3-D chart.

Top

Methods

	Name	Description
	_ApplyDataLabels	Reserved for internal use.
	_Dummy23	Reserved for internal use.
	_Evaluate	Reserved for internal use.
	_PrintOut	Reserved for internal use.
	_Protect	Reserved for internal use.
	_SaveAs	Reserved for internal use.
	Activate	Makes the current chart the active chart.
	ApplyChartTemplate	Applies a standard or custom chart type to a chart.
	ApplyCustomType	Applies a standard or custom chart type to a chart.
	ApplyDataLabels	Applies data labels to a point, a series, or all the series in a chart.
	ApplyLayout	Applies the layouts shown in the ribbon.
	Arcs	Reserved for internal use.
	AreaGroups	On a 2-D chart, returns 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	Reserved for internal use.
	Axes	Returns 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).
	Buttons	Reserved for internal use.
	ChartGroups	Returns an object that represents either a single chart group (a ChartGroup object) or a collection of all the chart groups in the chart (a ChartGroups object). The returned collection includes every type of group.
	ChartObjects	Returns 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. You can use this method to quickly format a chart without setting all the individual properties. This method is non-interactive, and it changes only the specified properties.
	CheckBoxes	Reserved for internal use.
	CheckSpelling	Checks the spelling of an object and 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	Copies the sheet to another location in the workbook.
	CopyChartBuild	Reserved for internal use.
	CopyPicture	Copies the selected object to the Clipboard as a picture.
	CreatePublisher	Reserved for internal use.This member is for Macintosh only and should not be used.
	Delete	Deletes the object.
	Deselect	Cancels the selection for the specified chart.
	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	Reserved for internal use.
	Drawings	Reserved for internal use.
	DropDowns	For callouts with an explicitly set drop value, this property returns the vertical distance (in points) from the edge of the text bounding box to the place where the callout line attaches to the text box. Read-only Single.
	Evaluate	Converts a Microsoft Excel name to an object or a value.
	Export	Exports the chart in a graphic format.
	ExportAsFixedFormat	Exports to a file of the specified format.
	GetChartElement	Returns information about the chart element at specified X and Y coordinates. This method is unusual in that you specify values for only the first two arguments. Microsoft Excel fills in the other arguments, and your code should examine those values when the method returns.
	GroupBoxes	Reserved for internal use.
	GroupObjects	Reserved for internal use.
	Labels	Reserved for internal use.
	LineGroups	On a 2-D chart, returns an object that represents either a single line chart group (a ChartGroup object) or a collection of the line chart groups (a ChartGroups collection).
	Lines	Reserved for internal use. f
	ListBoxes	Returns or sets the text entries in the specified list box or a combo box, as an array of strings, or returns or sets a single text entry. An error occurs if there are no entries in the list.
	Location	Moves the chart to a new location.
	Move	Moves the sheet to another location in the workbook.
	OLEObjects	Returns an object that represents either a single OLE object (an OLEObject) or a collection of all OLE objects (an OLEObjects collection) on the chart or sheet.
	OptionButtons	Reserved for internal use.
	Ovals	Reserved for internal use.
	Paste	Pastes chart data from the Clipboard into the specified chart.
	Pictures	Reserved for internal use.
	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 object.
	PrintOutEx	Reserved for internal use.
	PrintPreview	Shows a preview of the object as it would look when printed.
	Protect	Protects a chart so that it cannot be modified.
	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	Reserved for internal use.
	Refresh	Updates the cache of the Chart or PivotTable object.
	SaveAs	Saves changes to the chart or worksheet in a different file.
	SaveChartTemplate	Saves a custom chart template to the list of available chart templates.
	ScrollBars	Reserved for internal use.
	Select	Selects the object.
	SeriesCollection	Returns an object that represents either a single series (a Series object) or a collection of all the series (a SeriesCollection collection) in the chart or chart group.
	SetBackgroundPicture	Sets the background graphic for a worksheet or chart.
	SetDefaultChart	Specifies the name of the chart template that Microsoft Excel uses when creating new charts.
	SetElement	Sets chart elements on a chart. Read/write.
	SetSourceData	Sets the source data range for the chart.
	Spinners	Reserved for internal use.
	TextBoxes	Reserved for internal use.
	Unprotect	Removes protection from a sheet or workbook. This method has no effect if the sheet or workbook isn't protected.
	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

See Also

Reference

_Chart Interface

Microsoft.Office.Interop.Excel Namespace