![]() 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.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |