how to make a doughnut chart in google sheets

Select the data range, go to Insert > Pivot Table, and choose the desired rows and values. For a doughnut chart, you'll typically want a category in the rows and a numerical value in the values section.

Since Google Sheets doesn't allow sorting pivot tables by values, you may need to create a helper column with numerical values corresponding to the categories. Then, you can sort the pivot table by this helper column.

If you want to filter the data displayed in the doughnut chart, you can add filters to the pivot table. This can be done by selecting the desired filter fields in the pivot table editor.

Select the pivot table range, go to Insert > Chart, and choose the pie chart type. This will create a standard pie chart based on the pivot table data.

In the chart editor, navigate to the 'Customize' tab. Here, you can adjust various settings, such as disabling the background and border, increasing the donut hole size (typically to 50%), changing the slice colors, and formatting the data labels.

Disable the chart title and legend (if desired), adjust the font styles and sizes, and copy the chart to your dashboard sheet. You may need to manually adjust the chart size and position to fit your layout.

If you want to include a legend for the doughnut chart, you'll need to create it manually. Insert a text box or shape, and list the categories and their corresponding colors.

To highlight specific slices or add visual cues, you can apply conditional formatting rules to the pivot table cells. This can be done by selecting the range and going to Format > Conditional Formatting.

Since Google Sheets doesn't have a built-in slicer functionality like Excel, you may need to create custom filters or link the doughnut chart to other visualizations on the same sheet for interactivity.