ChartGroup Object Members

  • Article
Excel Developer Reference

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

Methods

  Name Description
Bb255893.methods(en-us,office.12).gif SeriesCollection Returns an object that represents either a single series (a Series object) or a collection of all the series (a SeriesCollection collection) in the chart or chart group.

Properties

  Name Description
Bb255893.properties(en-us,office.12).gif Application When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
Bb255893.properties(en-us,office.12).gif AxisGroup Returns an XlAxisGroup value that represents the type of axis group.
Bb255893.properties(en-us,office.12).gif BubbleScale Returns or sets the scale factor for bubbles in the specified chart group. Can be an integer value from 0 (zero) to 300, corresponding to a percentage of the default size. Applies only to bubble charts. Read/write Long.
Bb255893.properties(en-us,office.12).gif DoughnutHoleSize Returns or sets the size of the hole in a doughnut chart group. The hole size is expressed as a percentage of the chart size, between 10 and 90 percent. Read/write Long.
Bb255893.properties(en-us,office.12).gif DownBars Returns a DownBars object that represents the down bars on a line chart. Applies only to line charts. Read-only.
Bb255893.properties(en-us,office.12).gif DropLines Returns a DropLines object that represents the drop lines for a series on a line chart or area chart. Applies only to line charts or area charts. Read-only.
Bb255893.properties(en-us,office.12).gif FirstSliceAngle Returns or sets the angle of the first pie-chart or doughnut-chart slice, in degrees (clockwise from vertical). Applies only to pie, 3-D pie, and doughnut charts. Can be a value from 0 through 360. Read/write Long.
Bb255893.properties(en-us,office.12).gif GapWidth Bar and Column charts: Returns or sets the space between bar or column clusters, as a percentage of the bar or column width. 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.
Bb255893.properties(en-us,office.12).gif Has3DShading True if the chart group has three-dimensional shading. This property only applies to surface charts and will return a run-time error if you try to set it to a non-surface chart. Read/write Boolean.
Bb255893.properties(en-us,office.12).gif HasDropLines True if the line chart or area chart has drop lines. Applies only to line and area charts. Read/write Boolean.
Bb255893.properties(en-us,office.12).gif HasHiLoLines True if the line chart has high-low lines. Applies only to line charts. Read/write Boolean.
Bb255893.properties(en-us,office.12).gif HasRadarAxisLabels True if a radar chart has axis labels. Applies only to radar charts. Read/write Boolean.
Bb255893.properties(en-us,office.12).gif 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. Applies only to 2-D stacked bar, 2-D stacked column, pie of pie, or bar of pie charts. Read/write Boolean.
Bb255893.properties(en-us,office.12).gif HasUpDownBars True if a line chart has up and down bars. Applies only to line charts. Read/write Boolean.
Bb255893.properties(en-us,office.12).gif HiLoLines Returns a HiLoLines object that represents the high-low lines for a series on a line chart. Applies only to line charts. Read-only.
Bb255893.properties(en-us,office.12).gif Index Returns a Long value that represents the index number of the object within the collection of similar objects.
Bb255893.properties(en-us,office.12).gif Overlap Specifies how bars and columns are positioned. Can be a value between – 100 and 100. Applies only to 2-D bar and 2-D column charts. Read/write Long.
Bb255893.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb255893.properties(en-us,office.12).gif RadarAxisLabels Returns a TickLabels object that represents the radar axis labels for the specified chart group. Read-only.
Bb255893.properties(en-us,office.12).gif SecondPlotSize Returns or sets the size of the secondary section of either a pie of pie chart or a bar of pie chart, as a percentage of the size of the primary pie. Can be a value from 5 to 200. Read/write Long.
Bb255893.properties(en-us,office.12).gif SeriesLines Returns a SeriesLines object that represents the series lines for a 2-D stacked bar, 2-D stacked column, pie of pie, or bar of pie chart. Read-only.
Bb255893.properties(en-us,office.12).gif ShowNegativeBubbles True if negative bubbles are shown for the chart group. Valid only for bubble charts. Read/write Boolean.
Bb255893.properties(en-us,office.12).gif SizeRepresents Returns or sets what the bubble size represents on a bubble chart. Can be either of the following XlSizeRepresents constants: xlSizeIsArea or xlSizeIsWidth. Read/write Long.
Bb255893.properties(en-us,office.12).gif 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.
Bb255893.properties(en-us,office.12).gif 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.
Bb255893.properties(en-us,office.12).gif UpBars Returns an UpBars object that represents the up bars on a line chart. Applies only to line charts. Read-only.
Bb255893.properties(en-us,office.12).gif VaryByCategories True if Microsoft Excel assigns a different color or pattern to each data marker. The chart must contain only one series. Read/write Boolean.