Using Pie Charts and Doughnut Charts in Excel

Excel 2016 2013 2010 2007 2003
If you have several parts of something one, you can demonstrate each item in one pie chart. But sometimes you want to demonstrate the changes in those parts, and a doughnut chart will help you to do this.
Format chart in Excel 365

For example:

  • if you have several companies that operate in one business, you can submit a part of every company in this business:
    Pie Chart in Excel 365
  • after the merger of some companies have received:
    Pie Chart 2 in Excel 365

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

   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

In the Insert Pie or Doughnut Chart dropdown list, choose the Doughnut Doughnut chart in Excel 365 chart.

   3.    Right-click in the chart area 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 in the chart area and choose Select Data... in the popup menu:
    Select Data in popup menu Excel 365

   4.    In the Select Data Source dialog box, 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:C19):

Edit Series in Excel 365

After adding the new data series, your doughnut chart can be like this:

Doughnut Chart 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.

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.