Microsoft Office Tutorials and References
In Depth Information
Figure 21-15. Illustrating chart groups
Note, however, that there is no ColumnChartGroups collection per se. The ColumnGroups method
actually returns a ChartGroups collection, but not the full collection that would be returned by:
ChartObject .ChartGroups
To illustrate, the chart in Figure 21-15 has two series. While each series has a line type, the
subtypes are different. One series has been formatted with a line type with no data point markers,
whereas the other has data markers. Accordingly, the code:
ActiveChart.LineGroups.Count
returns the value 2 , since there are two distinct ChartGroup objects that fit in the LineGroups
collection.
Figure 21-15. Illustrating chart groups
The Chart object has the following methods that return corresponding collections of ChartGroup
objects:
AreaGroups
BarGroups
ColumnGroups
DoughnutGroups
LineGroups
PieGroups
RadarGroups
XYGroups
There are also some members of the Chart object that return chart groups for 3-D charts. They are:
Area3DGroup, Bar3DGroup, Column3DGroup, Line3DGroup, Pie3DGroup, and SurfaceGroup.
These members are singular because they return a single ChartGroup object.
The portion of the Excel object model that relates to ChartGroup objects is shown in Figure 21-16 .
Figure 21-16. The ChartGroup object
 
 
 
Search JabSto ::




Custom Search