Pie charts are useful for illustrating the proportions that several components contribute to a whole.
Building a pie chart
Ignoring fields that are hidden from the visualization, pie chart visualizations require one dimension and one measure in the Data section. More dimensions or measures prevent a pie chart from rendering.
Pie charts can visualize a maximum of 50 rows of data. You can use filters or the Row Limit option to limit your data if needed.
You can edit pie charts in the visualization menu. Click Edit in the upper right corner of the visualization tab.
Options listed below may be grayed out or hidden if they conflict with other settings that you have chosen.
Plot menu options
You can change how individual sections of the pie chart are labeled:
- None: Labels and legend are not displayed.
- Legend: Displays the legend to the right of the visualization. This is the default option.
- Labels: Displays lines marking the individual sections of the pie chart. You can customize the information that displays next to these lines. See the Label Type section below for details.
When Value Labels is set to Labels, you can customize the format of those labels:
- Label: Displays the series name.
- Value: Displays the numeric value associated with the pie slice.
- Label — Value: Displays the series name in bold first, then the numeric value.
- Percent: Displays the percentage of the pie slice as a portion of the total pie.
- Label — Percent: Displays the series name in bold first, then the percentage.
You can format a pie chart as a donut chart, by setting the radius for the "donut hole." This field accepts integers between 0 and 100, representing the percentage of the pie chart's total width (i.e., diameter) that will make up the hole. If no value is set the chart appears as a normal pie chart.
Start Angle and End Angle
You can control whether a pie chart appears as a full circle or as a portion of a circle. These fields use the 360-degree angles of a circle, and numbers between -360 and 360 can be entered. The End Angle must be a more positive number than the Start Angle; if it's not, the visualization defaults to a full circle. If no values are entered in Start Angle and End Angle, the chart also defaults to a full circle. Your full data results appear within that portion of the circle, adjusted to fit that space.
If you enter a Start Angle of
0 and an End Angle of
90, your data appears within the upper right quarter of a circle:
If you enter a Start Angle of
-270 and an End Angle of
-90, your data appears as the bottom half of a circle:
Series menu options
You can reverse the colors used on a palette. For a categorical palette, this applies the last color in the palette to the first series, the second-to-last color in the palette to the second series, and so on. For a sequential or diverging palette, this applies the color at the right end of the palette to the first series and move left on the palette for the remaining series.
You can customize each series in the chart in several ways:
- Click the arrow next to a series to expand its options.
- Click on the color swatch to select a custom color for the series. This overrides the color palette defined by the Colors option.
- Enter a custom series label if desired. This impacts the chart legend and tooltips.