Properties and Methods of the Chart Object

The 91 properties and methods of the Chart object are shown in Table 21-7.

Table 21-7. Members of the Chart Object

_ApplyDataLabels<v10>

DoughnutGroups

PieGroups

_CodeName

DrawingObjects

PivotLayout<v9>

_Dummy23

Drawings

PlotArea

_Evaluate

DropDowns

PlotBy

_Print√ľut<v9>

Elevation

PlotVisibleOnly

_Protect<v10>

Evaluate

Previous

_SaveAs<v10>

Export

PrintOut

Activate

Floor

PrintPreview

Application

GapDepth

Protect

ApplyCustomType

GetChartElement

ProtectContents

ApplyDataLabels

GroupBoxes

ProtectData

Arcs

GroupObjects

ProtectDrawingObj ects

Area3DGroup

HasAxis

ProtectFormatting

AreaGroups

HasDataTable

ProtectGoalSeek

AutoFormat

HasLegend

ProtectionMode

AutoScaling

HasPivotFields<v9>

ProtectSelection

Axes

HasTitle

RadarGroups

Bar3DGroup

HeightPercent

Rectangles

BarGroups

Hyperlinks

Refresh

BarShape

Index

RightAngleAxes

Buttons

Labels

Rotation

ChartArea

Legend

SaveAs

ChartGroups

Line3DGroup

Scripts<v9>

ChartObjects

LineGroups

ScrollBars

ChartTitle

Lines

Select

ChartType

ListBoxes

SeriesCollection

ChartWizard

Location

SetBackgroundPicture

CheckBoxes

MailEnvelope<v10>

SetSourceData

CheckSpelling

Move

Shapes

CodeName

Name

ShowWindow

Column3 DGroup

Next

Size With Window

ColumnGroups

OLEObjects

Spinners

Copy

OnDoubleClick

SubType

CopyChartBuild

OnSheetActivate

SurfaceGroup

CopyPicture

OnSheetDeactivate

Tab<v10>

Corners

OptionButtons

TextBoxes

CreatePublisher

Ovals

Type

Creator

PageSetup

Unprotect

DataTable

Parent

Visible

Delete

Paste

Walls

DepthPercent

Perspective

WallsAndGridlines2D

Deselect

Pictures

XYGroups

DisplayBlanksAs

Pie3DGroup

Table 21-8 shows the members of the Chart object that return children of the Chart object, along with the objects that they return. Note that several members can return a single object or a collection of objects.

Table 21-8. Members that Return Children

Name

Return Type

Application

Application

Area3DGroup

ChartGroup

AreaGroups

ChartGroup(s)

Axes

Axis/Axes

Bar3DGroup

ChartGroup

BarGroups

ChartGroup(s)

ChartArea

ChartArea

ChartGroups

ChartGroup(s)

ChartObjects

ChartObject(s)

ChartTitle

ChartTitle

Column3 DGroup

ChartGroup

ColumnGroups

ChartGroup(s)

Corners

Corners

DataTable

DataTable

DoughnutGroups

ChartGroup(s)

Floor

Floor

Hyperlinks

Hyperlinks

Legend

Legend

Line3DGroup

ChartGroup

LineGroups

ChartGroup(s)

Location

Chart

OLEObjects

OLEObject(s)

PageSetup

PageSetup

Pie3DGroup

ChartGroup

PieGroups

ChartGroup(s)

PlotArea

PlotArea

RadarGroups

ChartGroup(s)

SeriesCollection

Series/SeriesCollection

Shapes

Shapes

SurfaceGroup

ChartGroup

Walls

Walls

XYGroups

ChartGroup(s)

Let us discuss a few of the members of the Chart object. (We have encountered many of these members in connection with other chart-related objects.)

0 0

Responses

Post a comment