Microsoft Office Tutorials and References
In Depth Information
The Chart Object Model
Figure 15-2: Using the help system to find properties and
methods of objects
The Chart Object Model
When you use VBA to work with charts, you’ll quickly discover that the Chart
object model is very complex. First, keep in mind that a Chart object can have
either of two different parent objects. The parent object of a chart on a Chart sheet
is the Workbook object that contains the Chart sheet. The object hierarchy is
Workbook
Chart
The parent object of an embedded chart is a ChartObject object. The parent of a
ChartObject object is a Worksheet . The object hierarchy for an embedded chart is
as follows:
Workbook
Worksheet
ChartObject
Chart
Search JabSto ::




Custom Search