create pie chart in excel using different data

Go to the Insert tab and select from other charts. Then select the data you want to show in the chart, including labels, by dragging the mouse across the cells. To do the same, first of all, create a basic table in Excel as shown below or something similar to it. You can draw a multilevel pie chart for this data. But sometimes you want to demonstrate the changes in those parts, and the doughnut chart will help you do this. With the use of two or more standard doughnut charts and synchronizing them with clever Excel values and formulas, you can do a lot.Įxcel can't create a multi level pie chart where everything is 'automatically' taken care of for you, but you have to find a way around to make the solution workable.įor instance, if you have several parts of something, you can demonstrate each item in one pie chart.

So I then started to play with the different available options within Excel and the next best thing came along: doughnut charts. Initially, I thought it could only be possible with shapes and smartart, but that is simply not doable, especially when your values change.

Create pie chart in excel using different data