![]() ![]() ![]() Click on the data point for the remaining percentage, click the Format tab, and select a light colour from the Shape Fill list. ![]() Double click on the Doughnut Chart itself (on the data series) and this should open the Data Series task pane (shown below Excel 2016, your version may open a dialog box).Click on the Legend (completely redundant in this situation) and press Delete on the keyboard to remove it.Click on the Chart Title placeholder and type a meaningful title.We will now apply some formatting steps to bring our Doughnut chart up a level. Format the Doughnut Chart to Make it Amazing It is however a little basic, so lets do some formatting to bring it to life. Click the Insert tab, Pie chart button and select the Doughnut chart (the location of the Doughnut chart button may differ on your Excel version).Īnd as easy as that, you have a Doughnut chart in Excel showing progress.Select the two values (range B2:B3 in this example).With these values we can now create the Doughnut chart. This formula subtracts the progress percentage from 1 to return the remaining percentage. You can do this by typing the following formula. You will need to calculate the remaining percentage in another cell. This is probably the result of some formula in a ‘real world’ situation.įor this example we have just typed a percentage into cell B2. You will probably have a percentage in a cell on your spreadsheet showing your progress toward the goal. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |