Doughnut charts are similar to Pie charts which has a hole in the center.For example, in the double doughnut, we have two years of data if we have 3 or 4 years of data, then we can create multiple doughnut charts. Multiple doughnut charts are also created in a similar way the only thing required to create multiple doughnuts is multiple matrices. Then the data labels will appear on the ring, as shown below.įollowing is an example of multiple doughnuts in excel: Multiple Doughnut Charts in Excel If we want the data figures on the ring then, select the ring and right-click select the option Add Data Labels. If we want to fill a single color for the entire ring, then deselect the option which is highlighted. We can adjust the Width, Transparency, Dash type etc., as per your requirements. Select the solid line and then change the required color for the border.Īfter applying the border to the selected rings, the results will look as shown below. If we want to add the border to the ring, select the ring or part of the ring in which you want to add a border. Please find the color box which is highlighted. Select the particular part of the selected ring and change the color as per your requirement. Observe the below image only the year 2018 is highlighted. To identify which ring you selected to observe the data (Data will highlight as per your ring selection). If we want a different color, select the particular ring we want to change the color. If we want to increase the softness of the edges, change the settings of softness by selecting Soft Edges at the bottom of the Glow menu. As per the selected color, the shadow will appear. If we want to apply the color shadow, use the menu Glow at the bottom of the “shadow” menu. select the required Shadow option.Īfter applying the shadow, we can adjust the shadow related options like Color, Transparency, size etc. If we want to add the shadow, select the middle option, which is highlighted. If we want to increase the gap between the rings, adjust the Doughnut Explosion. We can observe the difference between 0 degrees and 90 degrees. If we want to change the angle of the doughnut, change the settings of “Angle of the first slice”. Now we can find the option Doughnut Hole Size at the bottom where you drag the percentage to reduce. To reduce the doughnuts hole size, select the doughnuts and right-click and then select Format data series. Then the below chart will appear on the screen with two doughnut rings. From Dropdown, select the doughnut symbol. Go to charts 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 as similar to the previous single doughnut chart. Here we are considering two years sales as shown below for the products X, Y, and Z. Let’s take an example of sales of a company.
With the help of a double doughnut chart, we can show the two matrices in our chart. Doughnut Chart in Excel – Example #2įollowing is an example of a doughnut chart in excel: Double Doughnut Chart in Excel So that Incomplete will pick automatically. 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 inprogess. From the right-side menu, select “Text options” and change the color to “Orange”. Select the text and right-click from the pop-up, 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 as per your doughnut color for that particular field. Select the Fill and select No Fill, then the blue color will disappear. Right-click on the text and select the format. For that input = (equal sign) in the text box and select the cell which shows 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, shown in the picture below.
Now to input, the percentage text selects the Doughnut Then click on Shapes under Illustrations option from Insert menu and select Rectangle box. The “Format Data Series” menu reduces the Doughnut Hole Size. When clicking on the Format Data series, a format menu appears on the right side. Select the chart and right-click a pop-up menu that will appear from that, select the Format Data Series.