Chart Properties (PowerPoint)

GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Properties

Name

Description

AlternativeText

Returns or sets the alternative text associated with a shape in a Web presentation. Read/write.

Application

When used without an object qualifier, returns an Application object that represents the Microsoft PowerPoint application. When used with an object qualifier, returns an Application object that represents the creator of the specified object (you can use this property with an Automation object to return the application of that object). Read-only.

AutoScaling

True if Microsoft Word scales a 3-D chart so that it is closer in size to the equivalent 2-D chart. The RightAngleAxes property must be True. Read/write Boolean.

BackWall

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

BarShape

Returns or sets the shape used for every series in a 3-D bar or column chart. Read/write XlBarShape.

CategoryLabelLevel

Returns or sets an XlCategoryLabel constant that specifies the source level of the chart category labels. Read-write.

ChartArea

Returns the complete chart area for the chart. Read-only ChartArea.

ChartColor

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

ChartData

Returns information about the linked or embedded data associated with a chart. Read-only ChartData.

ChartStyle

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

ChartTitle

Returns the title of the specified chart. Read-only ChartTitle.

ChartType

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

Creator

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

DataTable

Returns the chart data table. Read-only DataTable.

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, in degrees, of the 3-D chart view. Read/write Long.

Floor

Returns the floor of the 3-D chart. Read-only Floor.

Format

Returns the ChartFormat object. Read-only.

GapDepth

Returns or sets the distance, as a percentage of the marker width, between the data series in a 3-D chart. 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 (from 5 through 500 percent). Read/write Long.

Legend

Returns the legend for the chart. Read-only Legend.

Name

Read/write

Parent

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

Perspective

Returns or sets the perspective for the 3-D chart view. Read/write Long.

PlotArea

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

PlotBy

Returns or sets the way columns or rows are used as data series on the chart. Read/write Long.

PlotVisibleOnly

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

RightAngleAxes

True if the chart axes are at right angles, independent of chart rotation or elevation. Read/write Boolean.

Rotation

Returns or sets the rotation, in degrees, of the 3-D chart view (the rotation of the plot area around the z-axis). Read/write Variant.

SeriesNameLevel

Returns or sets an XlSeriesNameLevel constant that specifies the source level of the series names. Read-write.

Shapes

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

ShowAllFieldButtons

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

ShowAxisFieldButtons

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

ShowDataLabelsOverMaximum

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

ShowLegendFieldButtons

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

ShowReportFilterFieldButtons

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

ShowValueFieldButtons

Returns or sets a value that indicates 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.

Title

Gets or sets a String that represents the title of the chart. Read/write.

Walls

Returns the walls of the 3-D chart. Read-only Walls.