ChartGroup Members (Word)

Article
05/06/2016

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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

Methods

Name	Description
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

Name	Description
Application	When used without an object qualifier, returns an Application object that represents the Microsoft Word application. When used with an object qualifier, returns an Application object that represents the creator of the specified object (you can use this property with an Automation object to return the application of that object). Read-only.
AxisGroup	Returns the type of axis group. Read/write XlAxisGroup.
BinsCountValue	Specifies the number of bins in the histogram chart. Read/write Long. Introduced in Office 2016.
BinsOverflowEnabled	Specifies whether a bin for values above the BinsOverflowValue is enabled. Read/write Boolean. Introduced in Office 2016.
BinsOverflowValue	If an BinsOverflowEnabled is True, specifies the value above which an overflow bin is displayed. Read/write Double. Introduced in Office 2016.
BinsType	Specifies how the horizontal axis of the histogram chart is formatted, by bins type. Read/write XlBinsType. Introduced in Office 2016.
BinsUnderflowEnabled	Specifies whether a bin for values below the BinsUnderflowValue is enabled. Read/write Boolean. Introduced in Office 2016.
BinsUnderflowValue	If an BinsUnderflowEnabled is True, specifies the value below which an underflow bin is displayed. Read/write Double. Introduced in Office 2016.
BinWidthValue	Specifies the number of points in each range. Read/write Double. Introduced in Office 2016.
BubbleScale	Returns or sets the scale factor for bubbles in the specified chart group. Read/write Long.
Creator	Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Long.
DoughnutHoleSize	Returns or sets the size of the hole in a doughnut chart group. Read/write Long.
DownBars	Returns the down bars on a line chart. Read-only DownBars.
DropLines	Returns the drop lines for a series on a line chart or area chart. Read-only DropLines.
FirstSliceAngle	Returns or sets the angle, in degrees (clockwise from vertical), of the first pie-chart or doughnut-chart slice. Read/write Long.
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. Read/write Long.
Has3DShading	True if a chart group has three-dimensional shading. Read/write Boolean.
HasDropLines	True if the line chart or area chart has drop lines. Read/write Boolean.
HasHiLoLines	True if the line chart has high-low lines. Read/write Boolean.
HasRadarAxisLabels	True if a radar chart has axis labels. Read/write Boolean.
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. Read/write Boolean.
HasUpDownBars	True if a line chart has up and down bars. Read/write Boolean.
HiLoLines	Returns the high-low lines for a series on a line chart. Read-only HiLoLines.
Index	Returns the index number of the object within the collection of similar objects. Read-only Long.
Overlap	Specifies how bars and columns are positioned. Read/write Long.
Parent	Returns the parent for the specified object. Read-only Object.
RadarAxisLabels	Returns the radar axis labels for the specified chart group. Read-only TickLabels.
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. Read/write Long.
SeriesLines	Returns the series lines for a 2-D stacked bar, 2-D stacked column, pie-of-pie, or bar-of-pie chart. Read-only SeriesLines.
ShowNegativeBubbles	True if negative bubbles are shown for the chart group. Read/write Boolean.
SizeRepresents	Returns or sets what the bubble size represents on a bubble chart. Read/write Long.
SplitType	Returns or sets the way the two sections of either a pie-of-pie chart or a bar-of-pie chart are split. Read/write XlChartSplitType.
SplitValue	Returns or sets the threshold value separating the two sections of either a pie-of-pie chart or a bar-of-pie chart. Read/write Variant.
UpBars	Returns the up bars on a line chart. Read-only UpBars.
VaryByCategories	True if Microsoft Word assigns a different color or pattern to each data marker. Read/write Boolean.

ChartGroup Members (Word)

Methods

Properties

Additional resources