GrapeCity.Documents.Excel.Drawing.IChartGroup

Interface IChartGroup

Namespace

GrapeCity.Documents.Excel.Drawing

Assembly

GcDocs.Excel.dll

Represents one or more series plotted in a chart with the same format. The ChartGroup object is a member of the IChartGroups collection.

public interface IChartGroup

Properties

AxisGroup

Returns or sets the group for the specified chart group or series.

AxisGroup AxisGroup { get; set; }

Property Value

AxisGroup

BinsCountValue

Gets or sets the number of bins in the histogram chart.

long BinsCountValue { get; set; }

Property Value

long

BinsOverflowEnabled

Gets or sets whether a bin for values above the BinsOverflowValue property is enabled.

bool BinsOverflowEnabled { get; set; }

Property Value

bool

BinsOverflowValue

Gets or sets the value above which an overflow bin is displayed. It only works if the BinsOverflowEnabled property is True.

double BinsOverflowValue { get; set; }

Property Value

double

BinsType

Gets or sets how the horizontal axis of the histogram chart is formatted.

BinsType BinsType { get; set; }

Property Value

BinsType

BinsUnderflowEnabled

Gets or sets whether a bin for values below the BinsUnderflowValue property is enabled.

bool BinsUnderflowEnabled { get; set; }

Property Value

bool

BinsUnderflowValue

Gets or sets the value below which an underflow bin is displayed. It only works if the BinsUnderflowEnabled property is True.

double BinsUnderflowValue { get; set; }

Property Value

double

BinWidthValue

Gets or sets the number of points in each range.

double BinWidthValue { get; set; }

Property Value

double

BubbleScale

Gets 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.

int BubbleScale { get; set; }

Property Value

int

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, between 10 and 90 percent.

int DoughnutHoleSize { get; set; }

Property Value

int

DownBars

Returns the IChartBars object that represents the down bars on a line chart. Applies only to line charts.

IChartBars DownBars { get; }

Property Value

IChartBars

DropLines

Returns the IChartLines object that represents the drop lines for a series on a line chart or area chart. Applies only to line charts or area charts.

IChartLines DropLines { get; }

Property Value

IChartLines

FirstSliceAngle

Gets 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.

int FirstSliceAngle { get; set; }

Property Value

int

GapWidth

Gets or sets the gap width. Bar and Column charts: Gets 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: Gets or sets the space between the primary and secondary sections of the chart.

int GapWidth { get; set; }

Property Value

int

HasDropLines

Gets or sets whether the chart has drop lines (True if the line chart or area chart has drop lines). Applies only to line and area charts.

bool HasDropLines { get; set; }

Property Value

bool

HasHiLoLines

Gets or sets whether the line chart has high-low lines (True if the line chart has high-low lines). Applies only to line charts.

bool HasHiLoLines { get; set; }

Property Value

bool

HasSeriesLines

Gets or sets whether the chart has series lines (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.

bool HasSeriesLines { get; set; }

Property Value

bool

HasUpDownBars

Gets or sets whether the line chart has up and down bars (True if a line chart has up and down bars). Applies only to line charts.

bool HasUpDownBars { get; set; }

Property Value

bool

HiLoLines

Returns a IChartLines object that represents the high-low lines for a series on a line chart. Applies only to line charts.

IChartLines HiLoLines { get; }

Property Value

IChartLines

Overlap

Gets or sets 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.

int Overlap { get; set; }

Property Value

int

Parent

Returns the parent object for the specified object.

IChart Parent { get; }

Property Value

IChart

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. Can be a value from 5 to 200.

int SecondPlotSize { get; set; }

Property Value

int

SeriesCollection

Returns an object that represents a collection of all the series (a ISeries collection) in the chart or chart group.

IEnumerable<ISeries> SeriesCollection { get; }

Property Value

System.Collections.Generic.IEnumerable<T><ISeries>

SeriesLines

Returns the IChartLines 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.

IChartLines SeriesLines { get; }

Property Value

IChartLines

ShowNegativeBubbles

Gets or sets whether to show negative bubbles (True if negative bubbles are shown for the chart group). Valid only for bubble charts.

bool ShowNegativeBubbles { get; set; }

Property Value

bool

SizeRepresents

Gets or sets what the bubble size represents on a bubble chart. Can be either of the following SizeRepresents constants: SizeIsArea or SizeIsWidth.

SizeRepresents SizeRepresents { get; set; }

Property Value

SizeRepresents

SplitType

Gets or sets the way the two sections of either a Pie of Pie chart or a Bar of Pie chart are split.

ChartSplitType SplitType { get; set; }

Property Value

ChartSplitType

SplitValue

Gets or sets the threshold value separating the two sections of either a Pie of Pie chart or a Bar of Pie chart.

int SplitValue { get; set; }

Property Value

int

UpBars

Returns an IChartBars object that represents the up bars on a line chart. Applies only to line charts.

IChartBars UpBars { get; }

Property Value

IChartBars

VaryByCategories

Gets or sets whether to use a different color or pattern for each data marker (True if Microsoft Excel assigns a different color or pattern to each data marker). The chart must contain only one series.

bool VaryByCategories { get; set; }

Property Value

bool