Author: Oscar Cronquist Article last updated on September 12, 2018

A doughnut chart is just like a pie chart showing the relationships of segments to a total except that the it also may contain multiple data series. Each ring in the chart represents a data series and the first series is closest to the center of the ring.

The doughnut chart is not a chart that I would recommend, it has the same issues as the pie chart, but also the rings are distorted because of their different sizes. This makes it really hard to compare the parts between rings, data labels must be used. The nature of this chart also makes it not practical to include more than 7 categories, each part becoming smaller and smaller for each category you add.

How to build

  1. Select data.
  2. Go to tab "Insert" on the ribbon.
  3. Press with mouse on "Insert Pie or Doughnut Chart" button.
  4. Press with left mouse button on the "Doughnut" button.

Add a second series

  1. Press with right mouse button on on chart.
  2. Press with mouse on "Select Data...".
  3. Press with left mouse button on "Add" button.
  4. Select the new series values you want to add to the chart.
  5. Select the series name as well.
  6. Press with left mouse button on OK button.
  7. Press with left mouse button on OK button.

Add data labels

  1. Press with right mouse button on on a ring.
  2. Press with mouse on "Add Data Labels..."
  3. Repeat step 1 - 2 with remaining doughnut rings.