Class ChartGroup (PowerPoint VBA)

The class ChartGroup represents one or more series plotted in a chart with the same format.

To use a ChartGroup class variable it first needs to be instantiated, for example

Dim chrg as ChartGroup
Set chrg = ActiveWindow.RangeFromPoint.Chart.ChartGroups(Index:=1)

ChartGroup class variables can be set using the ChartGroups.Item procedure.

Methods

CategoryCollection - Returns all the visible categories in the chart group, or the specified visible category.

FullCategoryCollection - Returns all the categories in the chart group, or the specified category, whether visible or filtered out.

SeriesCollection - Returns all the series in the chart group.

Properties

AxisGroup returns the type of axis group.

BinsCountValue specifies the number of bins in the histogram chart.

BinsOverflowEnabled specifies whether a bin for values above the ChartGroup.BinsOverflowValue property (PowerPoint) is enabled.

BinsOverflowValue if an ChartGroup.BinsOverflowEnabled property (PowerPoint) is True, specifies the value above which an overflow bin is displayed.

BinsType specifies how the horizontal axis of the histogram chart is formatted, by bins type.

BinsUnderflowEnabled specifies whether a bin for values below the ChartGroup.BinsUnderflowValue property (PowerPoint) is enabled.

BinsUnderflowValue if ChartGroup.BinsUnderflowEnabled property (PowerPoint) is True, specifies the value below which an underflow bin is displayed.

BinWidthValue specifies the number of points in each range.

BubbleScale returns or sets the scale factor for bubbles in the specified chart group.

DoughnutHoleSize returns or sets the size of the hole in a doughnut chart group.

DownBars returns the down bars on a line chart.

DropLines returns the drop lines for a series on a line chart or area chart.

FirstSliceAngle returns or sets the angle, in degrees (clockwise from vertical), of the first pie-chart or doughnut-chart slice.

GapWidth for bar and column charts, returns or sets the space, as a percentage of the bar or column width, between bar or column clusters. For pie-of-pie and bar-of-pie charts, returns or sets the space between the primary and secondary sections of the chart.

Has3DShading true if a chart group has three-dimensional shading.

HasDropLines true if the line chart or area chart has drop lines.

HasHiLoLines true if the line chart has high-low lines.

HasRadarAxisLabels true if a radar chart has axis labels.

HasSeriesLines true if a stacked column chart or bar chart has series lines or if a pie-of-pie chart or bar-of-pie chart has connector lines between the two sections.

HasUpDownBars true if a line chart has up and down bars.

HiLoLines returns the high-low lines for a series on a line chart.

Index returns the index number of the object within the collection of similar objects.

Overlap specifies how bars and columns are positioned.

RadarAxisLabels returns the radar axis labels for the specified chart group.

SecondPlotSize returns or sets the size, as a percentage of the primary pie, of the secondary section of either a pie-of-pie chart or a bar-of-pie chart.

SeriesLines returns the series lines for a 2D stacked bar, 2D stacked column, pie-of-pie, or bar-of-pie chart.

ShowNegativeBubbles true if negative bubbles are shown for the chart group.

SizeRepresents returns or sets what the bubble size represents on a bubble chart.

SplitType returns or sets the way the two sections of either a pie-of-pie chart or a bar-of-pie chart are split.

SplitValue returns or sets the threshold value separating the two sections of either a pie-of-pie chart or a bar-of-pie chart.

UpBars returns the up bars on a line chart.

VaryByCategories true if Microsoft Word assigns a different color or pattern to each data marker.

CategoryCollection - Represents the collection of visible chart categories in the presentation.

DownBars - Represents the down bars in a chart group.

DropLines - Represents the drop lines in a chart group.

HiLoLines - Represents the high-low lines in a chart group.

SeriesCollection - Represents a collection of all the Series objects in the specified chart or chart group.

SeriesLines - Represents series lines in a chart group.

TickLabels - Represents the tick-mark labels associated with tick marks on a chart axis.

UpBars - Represents the up bars in a chart group.