how to create a percentage pie chart in excel

To reduce the doughnut hole size, select the doughnuts, right-click, and then select Format data series. Then the below chart will appear on the screen with two doughnut rings. From the Dropdown, select the doughnut symbol. Go to charts and select the PIE chart drop-down menu. Select the data alone without headers, as shown in the below image. Now we will create a doughnut chart similar to the previous single doughnut chart. Here we are considering two years of sales, as shown below for the products X, Y, and Z. Let’s take an example of the sales of a company. With the help of a double doughnut chart, we can show the two matrices in our chart. So that Incomplete will pick automatically.įollowing is an example of a doughnut chart in Excel: Double Doughnut Chart in Excel We can observe the changes in the chart and text if we input the formula in “Incomplete,” like 100%-completed-Work InProgress. Now change the percentages and see how the chart changes. Similarly, input the text for incomplete and work in progress. Select “Text options” from the right-side menu and change the color to “Orange”. Select the text, right-click from the pop-up, and select the formatting data series, and a menu will appear on the right side. Now it is showing in Orange color hence we will set the text color also in “Orange”. Now apply a format to the text per your doughnut color for that particular field.

Select the Fill and No Fill, then the blue color disappears. Right-click on the text and select the format. 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. Now click on the + symbol that appears top right of the chart, which will open the popup.

How to create a percentage pie chart in excel