Skip to content

Latest commit

 

History

History
95 lines (71 loc) · 3.97 KB

Excel.ChartGroup(object).md

File metadata and controls

95 lines (71 loc) · 3.97 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
ChartGroup object (Excel)
vbaxl10.chm567072
vbaxl10.chm567072
Excel.ChartGroup
7eee66c5-04a7-fd86-6e34-4c22ccaf8de0
03/29/2019
medium

ChartGroup object (Excel)

Represents one or more series plotted in a chart with the same format.

Remarks

A chart contains one or more chart groups, each chart group contains one or more Series objects, and each series contains one or more Points objects.

For example, a single chart might contain both a line chart group that contains all the series plotted with the line chart format, and a bar chart group that contains all the series plotted with the bar chart format. The ChartGroup object is a member of the ChartGroups collection.

Use ChartGroups (index), where index is the chart-group index number, to return a single ChartGroup object.

Because the index number for a particular chart group can change if the chart format used for that group is changed, it may be easier to use one of the named chart group shortcut methods to return a particular chart group. The PieGroups method returns the collection of pie chart groups in a chart, the LineGroups method returns the collection of line chart groups, and so on. Each of these methods can be used with an index number to return a single ChartGroup object, or without an index number to return a ChartGroups collection.

Example

The following example adds drop lines to chart group 1 on chart sheet 1.

Charts(1).ChartGroups(1).HasDropLines = True

If the chart has been activated, you can use the ActiveChart property.

Charts(1).Activate 
ActiveChart.ChartGroups(1).HasDropLines = True

Methods

Properties

See also

[!includeSupport and feedback]