Chapter The Chart Object

Excel charts are represented by Chart objects in the Excel object model. Since charts are quite complex, the Chart object is one of the most complicated in the object model.

To set the terminology, Figure 21-1 shows a typical chart that has been labeled with some of the commonly used chart-related terms.

Figure 21-1. Some chart terminology

Figure 21-1. Some chart terminology

Figure 21-2 shows the Chart object and its immediate children.

Figure 21-2. The Chart object

- 'o Chen

+

?U Axes

+

To Chert

+

1 o ChafVvaa

ft}

?o Charts roup

?U ChartGroups

+

?U ChsrtObjects

?o ChortTitle

?Q Corners

+

-?o OotoTable

+

?D FliJOr

?U Hyperlinks

-t

?D Lisgaticf

E£}~

?U OLEObjads

+

7o PageSetup

+

7o PiuotLer/Dulc^i

io PloiAjfea

+

7U SeriesOallectiDr

?U Shapes

~)o Tab<v10>

■+

? a Walls

0 0

Post a comment