how to create a percentage pie chart in excel

For that input = (equal sign) in the text box, select the cell showing the value of completed status that is B2. Now give the formula to represent the status of the project. Now click on the inserted rectangle shape and select the Text box in the picture below. Then click on Shapes under the Illustrations option from the Insert menu and select the Rectangle box. To input the percentage text, select Doughnut. Currently, it is 75% now, reduced to 50%. The “Format Data Series” menu reduces the Doughnut Hole Size. From that, select the Format Data Series.Ī formatted menu appears on the right when clicking the Format Data series. Select the chart and right-click a pop-up menu that will appear. Once you do that, the chart will look like below.

Untick the Chart Title and Legend to remove the text in the chart. Its name eludes me now.Now click on the + symbol that appears top right of the chart, which will open the popup. There's a book about a guy who used to do stuff like that.

If you could divide a pie up, and then put it back together again and have there be more than you started with, that would be a really useful party trick. In this way a stacked bar chart can represent changing proportions much more naturally and sensibly than any pie. If you want to compare changes across time, it is a much better idea to have TIME on at least one of your axes, with lines or blocks of color representing change. Using multiple pie charts means the viewer has to remember what the chart 2 slides ago looked like, or at the very least try and make a spatial comparison between 2 circular areas. You'll always have more success with the number (for all sorts of reasons). Now try reciting a random nine digit number. Try closing your eyes and visualising the room around you in detail. Most people's visual working memory is very poor, in contrast to their auditory working memory. The other terrible, criminal (aarghh!, my eyes!) mistake to make is to use multiple pie charts with multiple colors. So if you must use such a chart, I suggest you group it into three: If there are multiple sections one simply cannot make out the relative proportions of the chart and it becomes meaningless. They are usually ok if there are two to three colours and there is only one of them AND you are speaking to people who only require a broad-strokes impression of the dominance of one area. I know everyone has told you not to use a pie chart.

How to create a percentage pie chart in excel