Chart Members (Word)

Represents a chart in a document.

Methods

Name

Description

ApplyChartTemplate

Applies a standard or custom chart type to a chart.

ApplyDataLabels

Applies data labels to all the series in a chart.

ApplyLayout

Applies the layouts shown in the ribbon.

Axes

Returns a collection of axes on the chart.

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 noninteractive, and it changes only the specified properties.

ClearToMatchStyle

Clears the chart elements formatting to automatic.

Copy

Not supported for this object.

CopyPicture

Copies the selected object to the Clipboard as a picture.

Delete

Deletes the object.

Export

Exports the chart in a graphic format.

GetChartElement

Returns information about the chart element at the specified x-coordinate and y-coordinate.

Paste

Pastes chart data from the Clipboard into the chart.

Refresh

Causes the specified chart to be redrawn immediately.

SaveChartTemplate

Saves a custom chart template to the list of available chart templates.

Select

Selects the object.

SeriesCollection

Returns all the series in the chart.

SetBackgroundPicture

Sets the background graphic for a chart.

SetDefaultChart

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

SetElement

Sets chart elements on a chart. Read/write MsoChartElementType.

SetSourceData

Sets the source data range for the chart.

Properties

Name

Description

Application

When used without an object qualifier, returns an Application object that represents the Microsoft Word 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.

ChartArea

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

ChartData

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

ChartGroups

Returns an object that represents either a single chart group or a collection of all the chart groups in the chart.

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.

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.

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.

PivotLayout

Not supported for this object.

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.

Shapes

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

ShowAllFieldButtons

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

ShowAxisFieldButtons

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

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 whether to display legend field buttons on a PivotChart. Read/write. Deprecated.

ShowReportFilterFieldButtons

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

ShowValueFieldButtons

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

SideWall

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

Walls

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