Find if Data Points are in the Second Pie or Bar on a Pie of Pie or Bar of Pie Chart

Possible Usage Scenarios

You can find if data points of series are in the second pie on Pie of Pie chart or in the bar of Bar of Pie chart using Aspose.Cells. Please use the ChartPoint.IsInSecondaryPlot property to determine it.

Please download the sample excel file used in the following sample code and see its console output. If you open the sample excel file, you will find, all the data points which are less than 10 are inside the bar of Bar of Pie chart as also shown by console output.

Find if Data Points are in the Second Pie or Bar on a Pie of Pie or Bar of Pie Chart

The following sample code shows how to find if data points are in the second pie or bar on a Pie of Pie or Bar of Pie chart.

Console Output

Please see the following console output generated after the execution of the above sample code with the sample excel file. If IsInSecondaryPlot is false, the data point is inside the Pie or if it is true, then data point is inside the Bar.

 Value: 15

IsInSecondaryPlot: false

Value: 9

IsInSecondaryPlot: true

Value: 2

IsInSecondaryPlot: true

Value: 40

IsInSecondaryPlot: false

Value: 5

IsInSecondaryPlot: true

Value: 4

IsInSecondaryPlot: true

Value: 25

IsInSecondaryPlot: false