Using Pie Charts and Doughnut Charts in Excel

Excel 2016
The pie and donut (in Excel, doughnut) charts are widely used to present multiple parts of something whole. Using any of these chart types in Excel, you can demonstrate each part in one chart keeping their proportions. You can also represent the changes in those parts using a doughnut chart:
Format chart in Excel 365

For example:

  • If you have several companies that operate in the same industry, you can represent a portion of each company in that industry:
    Pie Chart in Excel 365
  • After the mergers and acquisitions, some companies have taken over other parts:
    Pie Chart 2 in Excel 365

To create one chart of this data, follow these steps:

Create a simple donut chart

   1.    Select the first data range (in this example, B3:C9).

   2.    On the Insert tab, in the Charts group, click the Insert Pie or Doughnut Chart button:

Pie Chart in Excel 365

From the Insert Pie or Doughnut Chart dropdown list, choose the Doughnut chart:

Doughnut chart in Excel 365

Add the second data series

   3.    Select the chart and do one of the following:

  • On the Chart Design tab, in the Data group, choose Select Data:
    Select Data in Excel 365
  • Right-click on the chart data series and choose Select Data... in the popup menu:
    Select Data in popup menu Excel 365

   4.    In the Select Data Source dialog box, under Legend Entries (Series), click the Add button:

Add data series in Excel 365

   5.    In the Edit Series dialog box, select the second data range (in this example, C13:C20):

Edit Series in Excel 365

After adding the new data series, the doughnut chart might look like this:

Simple doughnut Chart in Excel 365

Add the data labels

   6.    To add the data labels, right-click on the data series and choose Add Data Labels -> Add Data Labels in the popup menu:

Add Data Label in Excel 365

Format data series

Make data series thinker

   7.    To make the data series (or rings of the donut chart) thicker, right-click on any data series and choose Format Data Series... in the popup menu:

Format data series in popup menu Excel 365

On the Format Data Series pane, in the Series Options group, in the Series Options section, type or choose the appropriate value in the Doughnut Hole Size field.

In this example, 25%:

Series Options in Excel 365

The chart will look more presentable:

Formatted doughnut Chart in Excel 365

Apply 3D effects

   8.    To add the 3D effect to the chart parts, on the Format Data Series pane (see step 7 how to open it), in the Effects group, in the 3-D Format section:

  • In the Top bevel list, select the preferred bevel type,
  • Optionally, type or select the values you need in the Width and Height fields.

For this example:

3-D Format Options in Excel 365

You can then make any other adjustments to get the look you desire.

See also this tip in French: Utiliser le graphique en secteurs ou en anneau dans Excel.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.