Enum ChartSplitType

ChartSplitType enumeration

Represents the way the two sections of either a pie of pie chart or a bar of pie chart are split.

public enum ChartSplitType

Values

NameValueDescription
Position0Represents the data points shall be split between the pie and the second chart by putting the last Split Position of the data points in the second chart
Value1Represents the data points shall be split between the pie and the second chart by putting the data points with value less than Split Position in the second chart.
PercentValue2Represents the data points shall be split between the pie and the second chart by putting the points with percentage less than Split Position percent in the second chart.
Custom3Represents the data points shall be split between the pie and the second chart according to the Custom Split values.
Auto4Represents the data points shall be split using the default mechanism for this chart type.

Examples

[C#]

namespace Demos
{
    using Aspose.Cells;
    using Aspose.Cells.Charts;
    using System;

    public class ChartSplitTypeDemo
    {
        public static void ChartSplitTypeExample()
        {
            // Create a new workbook
            Workbook workbook = new Workbook();
            // Add a new worksheet to the workbook
            Worksheet worksheet = workbook.Worksheets[0];

            // Add sample data for the chart
            worksheet.Cells["A1"].PutValue("Category");
            worksheet.Cells["A2"].PutValue("A");
            worksheet.Cells["A3"].PutValue("B");
            worksheet.Cells["A4"].PutValue("C");
            worksheet.Cells["A5"].PutValue("D");

            worksheet.Cells["B1"].PutValue("Value");
            worksheet.Cells["B2"].PutValue(10);
            worksheet.Cells["B3"].PutValue(20);
            worksheet.Cells["B4"].PutValue(30);
            worksheet.Cells["B5"].PutValue(40);

            // Add a Pie of Pie chart to the worksheet
            int chartIndex = worksheet.Charts.Add(ChartType.Area, 5, 0, 20, 10);
            Chart chart = worksheet.Charts[chartIndex];

            // Add series to the chart
            chart.NSeries.Add("B2:B5", true);
            chart.NSeries.CategoryData = "A2:A5";

            // Save the workbook
            workbook.Save("ChartSplitTypeExample.xlsx");
            workbook.Save("ChartSplitTypeExample.pdf");
        }
    }
}

See Also