Link the actual value (in this case, cell D4) to the text box. Insert a Text Box.Ĭlean up the object, remove the background and border from the Text box. To do this, click on the ribbon and choose the Insert tab. Last but not least, we’ll prepare the label for the actual value. Step 3 – Insert a Text box and connect actual value Again, we strongly recommend you to use flat colors like blue and grey. In this example, the value is 63%.įinally, apply your preferred color theme. You can modify the doughnut hole size property. Right-click, then choose Format Data Point. Select the reminder value section of the outer ring. Next, press Ctrl + V to duplicate the doughnut chart. Select the chart and press Control + C to copy it. Now remove all unwanted items from the chart area.ĭelete the background, title, and borders. Select the data range and insert a doughnut chart. In this example, we’ll show you a brand new method to create a progress circle chart. After that, calculate the reminder value using this simple formula. D5 displays the reminder value to 100%.Īdd the actual value, for example, 45%. Create this initial data set below.Ĭell D4 will show the actual value. Let us see how to make it from the ground up! Step 1 – Set up the source dataĪs first, we need to do is set up the source data. It’s an excellent chart that requires two doughnut charts and a simple formula.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |