Chart Properties (Excel)

This object has the following properties:

Name

Description

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

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. Read/write Boolean.

BackWall

Returns a Walls object that allows the user to individually format the back wall of a 3-D chart. Read-only.

BarShape

Returns or sets the shape used with the 3-D bar or column chart. Read/write XlBarShape.

CategoryLabelLevel

Returns a XlCategoryLabelLevel Enumeration (Excel) constant referring to the level of where the category labels are being sourced from. Integer Read/Write.

ChartArea

Returns a ChartArea object that represents the complete chart area for the chart. Read-only.

ChartColor

Returns or sets an Integer that represents the color scheme for the chart. Read-write.

ChartStyle

Returns or sets the chart style for the chart. Read/write Variant.

ChartTitle

Returns a ChartTitle object that represents the title of the specified chart. Read-only.

ChartType

Returns or sets the chart type. Read/write XlChartType.

CodeName

Returns the code name for the object. Read-only String.

Creator

Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.

DataTable

Returns a DataTable object that represents the chart data table. Read-only.

DepthPercent

Returns or sets the depth of a 3-D chart as a percentage of the chart width (between 20 and 2000 percent). Read/write Long.

DisplayBlanksAs

Returns or sets the way that blank cells are plotted on a chart. Can be one of the XlDisplayBlanksAs constants. Read/write Long.

Elevation

Returns or sets the elevation of the 3-D chart view, in degrees. Read/write Long.

Floor

Returns a Floor object that represents the floor of the 3-D chart. Read-only.

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. Read/write Long.

HasAxis

Returns or sets which axes exist on the chart. Read/write Variant.

HasDataTable

True if the chart has a data table. Read/write Boolean.

HasLegend

True if the chart has a legend. Read/write Boolean.

HasTitle

True if the axis or chart has a visible title. Read/write Boolean.

HeightPercent

Returns or sets the height of a 3-D chart as a percentage of the chart width (between 5 and 500 percent). Read/write Long.

Hyperlinks

Returns a Hyperlinks collection that represents the hyperlinks for the chart.

Index

Returns a Long value that represents the index number of the object within the collection of similar objects.

Legend

Returns a Legend object that represents the legend for the chart. Read-only.

MailEnvelope

Rrepresents an e-mail header for a document.

Name

Returns or sets a String value representing the name of the object.

Next

Returns a Worksheet object that represents the next sheet.

PageSetup

Returns a PageSetup object that contains all the page setup settings for the specified object. Read-only.

Parent

Returns the parent object for the specified object. Read-only.

Perspective

Returns or sets a Long value that represents the perspective for the 3-D chart view.

PivotLayout

Returns a PivotLayout object that represents the placement of fields in a PivotTable report and the placement of axes in a PivotChart report. Read-only.

PlotArea

Returns a PlotArea object that represents the plot area of a chart. Read-only.

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. Read/write Long.

PlotVisibleOnly

True if only visible cells are plotted. False if both visible and hidden cells are plotted. Read/write Boolean.

Previous

Returns a Worksheet object that represents the next sheet.

PrintedCommentPages

Returns the number of comment pages that will be printed for the current chart. Read-only

ProtectContents

True if the contents of the sheet are protected. For a chart, this protects the entire chart. To turn on content protection, use the Protect method with the Contents argument set to True. Read-only Boolean.

ProtectData

True if series formulas cannot be modified by the user. Read/write Boolean.

ProtectDrawingObjects

True if shapes are protected. To turn on shape protection, use the Protect method with the DrawingObjects argument set to True. Read-only Boolean.

ProtectFormatting

True if chart formatting cannot be modified by the user. Read/write Boolean.

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. Read-only Boolean.

ProtectSelection

True if chart elements cannot be selected. Read/write Boolean.

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. Read/write Boolean.

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. Read/write Variant.

SeriesNameLevel

Returns a XlSeriesNameLevel Enumeration (Excel) constant referring to the level of where the series names are being sourced from. Integer Read/Write.

Shapes

Returns a Shapes collection that represents all the shapes on the chart sheet. Read-only.

ShowAllFieldButtons

Returns or sets whether to display all field buttons on a PivotChart. Read/write

ShowAxisFieldButtons

Returns or sets whether to display axis field buttons on a PivotChart. Read/write

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

ShowLegendFieldButtons

Returns or sets whether to display legend field buttons on a PivotChart. Read/write

ShowReportFilterFieldButtons

Returns or sets whether to display the report filter field buttons on a PivotChart. Read/write

ShowValueFieldButtons

Returns or sets whether to display the value field buttons on a PivotChart. Read/write

SideWall

Returns a Walls object that allows the user to individually format the side wall of a 3-D chart. Read-only.

Tab

Returns a Tab object for a chart.

Visible

Returns or sets an XlSheetVisibility value that determines whether the object is visible.

Walls

Returns a Walls object that represents the walls of the 3-D chart. Read-only.

Show:
© 2014 Microsoft