Excel Charts - Doughnut Chart

Doughnut charts show the size of items in a data series, proportional to the sum of the items. The doughnut chart is similar to a pie chart, but it can contain more than one data series.

Step 1 − Arrange the data in columns or rows on the worksheet.

Step 2 − Select the data.

Step 3 − On the INSERT tab, in the Charts group, click the Pie chart icon on the Ribbon. It is used to insert a Doughnut chart also.

Insert Doughnut chart

You will see the different types of Doughnut charts available.

Types of Doughnut chart

Step 4 − Point your mouse on the Doughnut icon. A preview of that chart type will be shown on the worksheet.

Doughnut

Consider using a Doughnut chart when −

  • You have more than one data series.

  • None of the values in your data are negative.

  • Almost none of the values in your data series are zero values.

  • You have no more than seven categories, all of which represent parts of the whole pie.

Doughnut Charts show data in rings, where each ring represents a data series. If percentages are shown in data labels, each ring will total to 100%.

Doughnut Chart

Doughnut charts are not easy to read. You can use a Stacked Column or Stacked Bar chart instead.

Advertisements