Gets or sets a value that specifies which data points should appear in the secondary chart of a Pie of Pie or Bar of Pie chart type.
A Double value that determines which data points should be displayed in the secondary chart.
Use the ChartView.SplitType property to determine how to split a Pie of Pie or Bar of Pie chart, and then set the SplitPosition property (or the ChartView.SecondPiePoints property if the custom split is specified) to adjust the number of data points that appear in the secondary chart.
Currently, the SpeadsheetControl does not display the Pie of Pie or Bar of Pie chart types. However, they can be loaded and stored in supported formats, and you can create and modify them programmatically.
The image below shows the Pie of Pie chart with the secondary chart containing the four smallest values (the workbook is opened in Microsoft® Excel®).
The example below demonstrates how to create a Pie of Pie chart and specify the number of data points that should appear in the secondary chart by setting the ChartView.SplitType and ChartView.SplitPosition properties. In this example, the last four values will be displayed in the secondary pie chart.
Worksheet worksheet = workbook.Worksheets["chartTask6"]; workbook.Worksheets.ActiveWorksheet = worksheet; // Create a Pie of Pie chart and specify its position. Chart chart = worksheet.Charts.Add(ChartType.PieOfPie, worksheet["B2:C11"]); chart.TopLeftCell = worksheet.Cells["E2"]; chart.BottomRightCell = worksheet.Cells["L16"]; // Specify the number of data points to be displayed in the secondary chart (the last four values). chart.Views.SplitType = OfPieSplitType.Position; chart.Views.SplitPosition = 4; // Show data labels as percentage values. chart.Views.DataLabels.ShowPercent = true;