Using Pie Charts and Doughnut Charts in Excel

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 of those parts and doughnut chart will help you to do this.
Format chart in Excel 2003

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 2003

After the merger of some companies have received:

Pie Chart 2 in Excel 2003

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

    1.    Select the first data range (in this example A4:B10).

    2.    Select Insert -> Chart... to open the Chart Wizard dialog box:

Chart Wizard in Excel 2003

Choose the Doughnut type, the Doughnut sub-type and then click Next >.

    3.    In the Step 2 of Chart Wizard, select the Series tab and click the Add button to add the second data range (in this example B14:B20):

Add data series in Excel 2003

Then click the Next > button.

    4.    In the Step 3 of Chart Wizard, hide the legend in the Legend tab, in the Data Labels tab, choose the Value checkbox and then click Next >.

    5.    In the Step 4 of Chart Wizard, click the Finish button:

Charts in Excel 2003

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

Thank you for visiting OfficeToolTips

We are glad to help you in your work. However, you are using ad blocker and our efforts will not be rewarded.

Please consider disabling ad blocker before continuing the reading.