Home / Statistical Tools / Analysis Tools / Piechart / Options
Options¶
The Options tab in the Pie Chart dialog lets you customize the chart output and control how slices are displayed and sorted.
Report Type¶
Show Category Name¶
When checked, displays the category name on each slice of the pie chart. Enabled by default.
Show Category Value¶
When checked, displays the raw count or sum value on each slice. This shows the actual number behind each category, not just the percentage. Disabled by default.
Show Category Percentage¶
When checked, displays the percentage of the total on each slice. This makes it easy to see each category's share of the whole. Enabled by default.
Display Pie Chart Report¶
When checked, creates a summary table alongside the chart showing each category's count and percentage of total. This provides a precise numeric breakdown that complements the visual chart. Enabled by default.
Slices¶
Maximum Number of Slices¶
Limits the number of slices displayed on the chart. Accepts values from 1 to 50, or 0 for no limit. Categories beyond this limit can be grouped into an "Others" slice (see below). This is useful when you have many categories and want to focus on the most significant ones.
Display Items Beyond Maximum Number of Slices into 'Others'¶
When checked, categories that exceed the Maximum Number of Slices are combined into a single "Others" slice. When unchecked, categories beyond the maximum are simply not displayed.
'Others' Group Caption¶
The label used for the combined category when items are grouped into "Others". Default is "Others" but you can customize this to any text (e.g., "Remaining", "Other Products", "Miscellaneous").
Sort Pie Slices¶
Controls the order of slices on the chart:
| Option | Description |
|---|---|
| Sort Descending | Largest slices first (standard order) |
| Sort Ascending | Smallest slices first |
The default is descending order to emphasize the most significant categories.
Sort Datasets¶
When analyzing multiple data columns, this controls the order in which charts appear:
| Option | Description |
|---|---|
| Sort by Name Ascending | Charts ordered A to Z by column name |
| Sort by Name Descending | Charts ordered Z to A by column name |
| Don't Sort | Charts appear in the order they were selected |