Represents one or more series plotted in a chart with the same format. The ChartGroup object is a member of the ChartGroups collection.
public interface class ChartGroup
[System.Runtime.InteropServices.Guid("00020859-0000-0000-C000-000000000046")] [System.Runtime.InteropServices.InterfaceType(2)] public interface ChartGroup
Public Interface ChartGroup
A chart contains one or more chart groups, each chart group contains one or more series, and each series contains one or more points. For example, a single chart might contain both a line chart group, containing all the series plotted with the line chart format, and a bar chart group, containing all the series plotted with the bar chart format.
index is the chart-group index number, to return a single ChartGroup object. If the chart has been activated, you can use the ActiveChart property.
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(Object) method returns the collection of pie chart groups in a chart, the LineGroups(Object) 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. The following chart group methods are available:
- AreaGroups(Object) method
- BarGroups(Object) method
- ColumnGroups(Object) method
- DoughnutGroups(Object) method
- LineGroups(Object) method
- PieGroups(Object) method
|Application Application Application||
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).
|AxisGroup AxisGroup AxisGroup||
Returns the group for the specified chart group or series.
|BubbleScale BubbleScale 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.
|Creator Creator Creator||
Returns a 32-bit integer that indicates the application in which this object was created. If the object was created in Microsoft Excel, this property returns the string XCEL, which is equivalent to the hexadecimal number 5843454C.
|DoughnutHoleSize DoughnutHoleSize 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.
|DownBars DownBars DownBars||
Returns a DownBars object that represents the down bars on a line chart. Applies only to line charts.
|DropLines DropLines 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.
|FirstSliceAngle FirstSliceAngle 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.
|GapWidth GapWidth 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.
|Has3DShading Has3DShading 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.
|HasDropLines HasDropLines HasDropLines||
True if the line chart or area chart has drop lines. Applies only to line and area charts.
|HasHiLoLines HasHiLoLines HasHiLoLines||
True if the line chart has high-low lines. Applies only to line charts.
|HasRadarAxisLabels HasRadarAxisLabels HasRadarAxisLabels||
True if a radar chart has axis labels. Applies only to radar charts.
|HasSeriesLines HasSeriesLines 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 stacked column charts, bar charts, Pie of Pie charts, or Bar of Pie charts.
|HasUpDownBars HasUpDownBars HasUpDownBars||
True if a line chart has up and down bars. Applies only to line charts.
|HiLoLines HiLoLines HiLoLines||
Returns a HiLoLines object that represents the high-low lines for a series on a line chart. Applies only to line charts.
|Index Index Index||
Returns the index number of the object within the collection of similar objects.
|Overlap Overlap 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.
|Parent Parent Parent||
Returns the parent object for the specified object.
|RadarAxisLabels RadarAxisLabels RadarAxisLabels||
Returns a TickLabels object that represents the radar axis labels for the specified chart group.
|SecondPlotSize SecondPlotSize 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.
|SeriesLines SeriesLines SeriesLines||
Returns a SeriesLines object that represents the series lines for a stacked bar chart or a stacked column chart. Applies only to stacked bar and stacked column charts.
|ShowNegativeBubbles ShowNegativeBubbles ShowNegativeBubbles||
True if negative bubbles are shown for the chart group. Valid only for bubble charts.
|SizeRepresents SizeRepresents SizeRepresents||
Returns or sets what the bubble size represents on a bubble chart. Can be either of the following XlSizeRepresents constants: xlSizeIsArea or xlSizeIsWidth.
|SplitType SplitType 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 SplitValue SplitValue||
Returns or sets the threshold value separating the two sections of either a Pie of Pie chart or a Bar of Pie chart.
|SubType SubType SubType||
Reserved for internal use.
|Type Type Type||
Reserved for internal use.
|UpBars UpBars UpBars||
Returns an UpBars object that represents the up bars on a line chart. Applies only to line charts.
|VaryByCategories VaryByCategories VaryByCategories||
True if Microsoft Excel assigns a different color or pattern to each data marker. The chart must contain only one series.
|CategoryCollection(Object) CategoryCollection(Object) CategoryCollection(Object)||
Returns an object that represents a collection of all of the visible categories (a CategoryCollection collection) in the chart group.
|FullCategoryCollection(Object) FullCategoryCollection(Object) FullCategoryCollection(Object)||
Returns an object that represents a collection of all of the visible and filtered categories (a CategoryCollection) in the chart group.
|SeriesCollection(Object) SeriesCollection(Object) SeriesCollection(Object)|