Special ChartType Properties > Special Pie Chart Properties > Building the "Other" Slice |
Pie charts are often more effective if unimportant values are grouped into an “Other” category. Use the pie ThresholdMethod property to select the grouping method to use. “SliceCutoff” is useful when you know the data value that should be grouped into the “Other” slice. “Percentile” is useful when you want a certain percentage of the pie to be devoted to the “Other” slice.
Use the ThresholdValue property to specify the value used for the ThresholdMethod. These properties are located on the ChartGroups Page Pie Tab on the Property Pages.
Use the MinSlices property to fine-tune the number of slices displayed before the “Other” slice. For example, when set to 5, the chart tries to display 5 slices before grouping data into the “Other” slice.
Note
You can use a value of "0" to represent the "other" slice in code that would normally expect a set value. For example, the series value returned by CoordToDataIndex will be 0 when the other slice is picked.