Creating pie charts and donut charts

The pie chart and the donut chart display the relation between values as well as the relation of a single value to the total. You can use a pie chart when you have a single data series with only positive values. You can use a donut chart when you have a single data series that includes negative values.

You can create a pie or donut chart on the sheet you are editing.

Do the following:

1. In a sheet, click to add a new visualization.
2. Under Visualization, select Pie chart or Donut chart.
3. Click Add and select a field or master dimension for the dimension.
4. Click Add and select a field or master measure for the measure.

The following settings are used by default in pie and donut charts.

• The top 10 sectors are presented in descending size order, clockwise.
• Colors are presented by dimension.
• Value labels are presented in percent.

When you have created the pie chart or donut chart, you might want to adjust its presentation in standard edit mode. For more information, see Presentation properties.

You can also change the chart's appearance in the advanced edit mode. In the properties panel in the advanced edit mode, you can adjust the chart's appearance and other settings. You can also add a radius measure. For information about styling, see Styling the pie chart or donut chart. For information about customizing other aspects of the chart's appearance, see Changing the appearance of a visualization.

Styling the pie chart or donut chart

With Advanced options turned on, you have a number of styling options available under Appearance in the properties panel.

Click Styling under Appearance > Presentation to further customize the styling of the chart. The styling panel contains various sections under the General and Chart tabs.

You can reset your styles by clicking next to each section. Clicking Reset all resets styles for all available tabs in the styling panel.

For general information about styling an individual visualization, see Applying custom styling to a visualization.

Customizing the text

You can set the text for the title, subtitle, and footnote under Appearance > General. To hide these elements, turn off Show titles.

The visibility of the different labels on the chart depends on chart-specific settings and label display options. These can be configured in the properties panel.

You can style the text that appears in the chart.

Do the following:

1. Click Advanced options.

2. In the properties panel, expand the Appearance section.

3. Under Appearance > Presentation, click Styling.

4. On the General tab, set the font, emphasis style, font size, and color for the following text elements:

   • Title

   • Subtitle

   • Footnote

5. On the Chart tab, set the font, font size, and color for the following text elements:

   • Dimension label: Style the label for the dimension shown in the chart.

   • Dimension value label: Style the individual dimension values.

   • Value label: Style the labels which display the measure value (displayed as a value or relative percentage) for each dimension value.

   • Legend title: Style the title of the legend.

   • Legend labels: Style the labels of the individual legend items.

Customizing the background

You can customize the background of the chart. The background can be set by color and image.

Do the following:

1. Click Advanced options.

2. In the properties panel, expand the Appearance section.

3. Under Appearance > Presentation, click Styling.

4. On the General tab of the styling panel, you can select a background color (single color or expression). You can also set the background to an image from your media library or from a URL.

   Information note

   To add a background image from a URL, the URL's origin needs to be added to the allowlist in your tenant's Content Security Policy. The origin must be added with the following Directive: img-src. This is done by a tenant administrator.

   For more information, see Creating a CSP entry.

   When using a background color, use the slider to adjust the opacity of the background.

   When using a background image, you can adjust image sizing and position.

Customizing the outline and shape

You can customize the outline surrounding the chart, as well as the shape and thickness of the slices.

Do the following:

1. Click Advanced options.

2. In the properties panel, expand the Appearance section.

3. Under Appearance > Presentation, click Styling.

4. On the Chart tab of the styling panel, under Outline, set the thickness and color of the outlines of the slices.

5. Under Corner radius, set the roundness of the corners of the slices.

6. If the chart is configured as a donut chart, under Inner radius, set the size of the hole at the center of the chart.

Customizing the border and shadow

You can customize the border and shadow of the chart.

Do the following:

1. Click Advanced options.

2. In the properties panel, expand the Appearance section.

3. Under Appearance > Presentation, click Styling.

4. On the General tab of the styling panel, under Border, adjust the Outline size to increase or decrease the border lines around the chart.

5. Select a color for the border.

6. Adjust the Corner radius to control the roundness of the border.

7. Under Shadow in the General tab, select a shadow size and color. Select None to remove the shadow.