Using Pie Charts and Doughnut Charts in Excel

For example, if you have several companies that operate in one business, you can submit a part of every company in this business:

After the merger of some companies have received:

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

   1.    Select the first data range (in this example B5:C10).

   2.    On the Insert tab, in the Charts group, choose the Other Charts button and then Doughnut:

   3.    Right-click in the chart area. In the popup menu select Select Data...:

   4.    In the Select Data Source dialog box, click the Add button:

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

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

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