Then build a normal flat pie chart using the chart wizard and drag it into some free space under the table. Then press the CTRL key and also highlight the four cells containing the totals, including the label Total. To create this first highlight the labels Drink, Shop1, Shop2 and Shop3. The first pie will show the totals for each shop. So your completed table is four columns by five rows, with the bottom row showing totals. Then add the label Total under the cell with the word Milk, and sum all the numbers for each shop.

Now add some figures for juice, water and milk for all three shops. Then in separate cells to the right of the heading Drink we have Shop1, Shop2 and Shop3. The first column has the heading Drink and the words Juice, Water and Milk in separate cells under the heading. Suppose we have a small table in Excel showing the number of drinks sold in three shops in a day.

The separate pies can then be grouped together to form a single item, our multiple pie. In this article we'll look at how to create a pie chart surrounded by several smaller pies, so several sets of data can be shown at the same time. However pie charts as you know only show one set of numbers at a time. If you've created pie charts in Excel you'll have found them very straightforward to build and easy to understand.

Create pie chart in excel two columns