GrapeCity.Documents.Excel.Drawing.IChartGroup

IChartGroup Interface

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

An IChartGroup is a member of the IChartGroups collection. Use this interface to access and configure group-level settings that apply to the series in the same chart group, such as axis grouping and chart-type-specific options.

Namespace: GrapeCity.Documents.Excel.Drawing

Assembly: DS.Documents.Excel.dll

Syntax

public interface IChartGroup

Public Interface IChartGroup

Examples

worksheet.Range["A1:B3"].Value = new object[,] {
    {"Month", "Sales"},
    {"Jan", 10},
    {"Feb", 15}
};
IChart chart = worksheet.Shapes.AddChart(ChartType.ColumnClustered, 10, 10, 300, 200).Chart;
chart.SeriesCollection.Add(worksheet.Range["A1:B3"]);
IChartGroup chartGroup = chart.ChartGroups[0];

Properties

Name	Description
AxisGroup	Gets or sets the axis group of the chart group.
BinWidthValue	Gets or sets the number of points in each range. Use this property to read the current range size configured for a histogram chart group.
BinsCountValue	Gets or sets the number of bins in the histogram chart. Use this property to read the current bin count configured for a histogram chart group.
BinsOverflowEnabled	Gets or sets whether a bin for values above the BinsOverflowValue property is enabled. This property applies to histogram charts and indicates whether values greater than the overflow threshold are grouped into a separate overflow bin.
BinsOverflowValue	Gets or sets the value above which an overflow bin is displayed. This property applies when BinsOverflowEnabled returns `true`.
BinsType	Gets or sets how the horizontal axis of the histogram chart is formatted. Use this property to read the current binning mode for a histogram chart group, such as automatic, bin count, bin size, or categorical binning.
BinsUnderflowEnabled	Gets or sets whether a bin for values below the BinsUnderflowValue property is enabled. This property applies to histogram charts and indicates whether values less than the underflow threshold are grouped into a separate underflow bin.
BinsUnderflowValue	Gets or sets the threshold value below which an underflow bin is displayed. This property applies to histogram charts and is used when the underflow bin is enabled through BinsUnderflowEnabled.
BubbleScale	Gets or sets the scale factor for bubbles in the specified chart group. The returned value is an integer from 0 to 300, representing a percentage of the default bubble size. This property applies only to bubble charts.
DoughnutHoleSize	Gets or sets the size of the hole in a doughnut chart group. The hole size is expressed as a percentage of the chart size, from 10 to 90.
DownBars	Gets the down bars for a line chart group. The returned IChartBars object represents the bars drawn for points where one line series decreases relative to another. This property applies only to line charts.
DropLines	Gets the IChartLines object that represents the drop lines for the chart group.
FirstSliceAngle	Gets or sets the angle of the first pie-chart or doughnut-chart slice in degrees.
GapWidth	Gets or sets the gap width for the chart group. For bar and column charts, the gap width specifies the space between bar or column clusters as a percentage of the bar or column width. For Pie of Pie and Bar of Pie charts, it specifies the space between the primary and secondary sections of the chart.
HasDropLines	Gets or sets whether the chart group has drop lines.
HasHiLoLines	Gets or sets whether the line chart has high-low lines.
HasSeriesLines	Gets or sets whether the chart group has series lines. Returns `true` if a stacked column chart or bar chart displays series lines, or if a Pie of Pie chart or Bar of Pie chart displays connector lines between the two sections. This property applies only to stacked column charts, bar charts, Pie of Pie charts, and Bar of Pie charts.
HasUpDownBars	Gets or sets whether the line chart has up and down bars.
HiLoLines	Gets the IChartLines object that represents the high-low lines for the chart group.
Overlap	Gets or sets how bars and columns are positioned in the chart group. The returned value can be between -100 and 100. This property applies only to 2-D bar charts and 2-D column charts.
Parent	Gets the parent IChart that contains this chart group. Use this property to access the chart that owns the current chart group after retrieving the group from ChartGroups.
SecondPlotSize	Gets 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. This property applies to Pie of Pie charts and Bar of Pie charts. The returned value is between 5 and 200.
SeriesCollection	Gets the collection of all series in the chart or chart group. Use the returned list to access the ISeries objects that belong to the current chart group.
SeriesLines	Gets the IChartLines object that represents the series lines for the chart group. Series lines connect the data values from each series in a stacked bar chart or stacked column chart. This property applies only to stacked bar and stacked column charts. Returns `null` if series lines are not enabled for the chart group.
ShowNegativeBubbles	Gets or sets whether negative bubbles are shown for the chart group. This property is valid only for bubble charts.
SizeRepresents	Gets or sets what the bubble size represents on a bubble chart. The returned value indicates whether bubble sizes are interpreted as SizeIsArea or SizeIsWidth.
SplitType	Gets or sets the way the two sections of either a Pie of Pie chart or a Bar of Pie chart are split. Use this property to determine which split rule is currently applied to the chart group.
SplitValue	Gets or sets the threshold value that separates the two sections of a Pie of Pie chart or a Bar of Pie chart. This property applies to Pie of Pie charts and Bar of Pie charts. The meaning of the returned value depends on the current split mode configured by SplitType.
UpBars	Gets the up bars for a line chart group. Up bars connect points where the last series in the chart group has a higher value than the first series. This property applies only to line charts.
VaryByCategories	Gets or sets whether the chart group uses a different color or pattern for each data marker. If this property is `true`, Microsoft Excel assigns a different color or pattern to each data marker. The chart must contain only one series.