How to create a doughnut chart

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

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

Add a second series

Press with right mouse button on on chart.
Press with mouse on "Select Data...".
Press with left mouse button on "Add" button.
Select the new series values you want to add to the chart.
Select the series name as well.
Press with left mouse button on OK button.
Press with left mouse button on OK button.

Add data labels

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

How to comment

How to add a formula to your comment
<code>Insert your formula here.</code>

Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >

How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.

Contact Oscar

You can contact me through this contact form