GrapeCity.Documents.Excel.Drawing.ChartSplitType

ChartSplitType Enum

Specifies how values are split into the secondary plot of a pie-of-pie or bar-of-pie chart.

Use this enumeration with the pie chart group's SplitType property to control which data points are moved from the primary plot to the secondary plot. Depending on the selected value, the split is based on position, value, percentage, or a custom data point selection.

Namespace: GrapeCity.Documents.Excel.Drawing

Assembly: DS.Documents.Excel.dll

Syntax

public enum ChartSplitType

Public Enum ChartSplitType

Examples

worksheet.Range["A1:B6"].Value = new object[,] {
    {"Category", "Sales"},
    {"North", 50},
    {"South", 12},
    {"East", 8},
    {"West", 30},
    {"Central", 5}
};
IShape shape = worksheet.Shapes.AddChart(ChartType.PieOfPie, 20, 20, 360, 230);
shape.Chart.SeriesCollection.Add(worksheet.Range["A1:B6"], RowCol.Columns, true, true);
shape.Chart.PieGroups[0].SplitType = ChartSplitType.SplitByValue;
shape.Chart.PieGroups[0].SplitValue = 10;

Fields

Name	Description
SplitByCustomSplit	Specifies that custom-selected data points are displayed in the second chart.
SplitByPercentValue	Specifies that the second chart displays values less than some percentage of the total value.The percentage is specified by the SplitValue property.
SplitByPosition	Specifies that the second chart displays the smallest values in the data series. The number of values to display is specified by the SplitValue property.
SplitByValue	Specifies that the second chart displays values less than the value specified by the SplitValue property.