Our data will allow us to input a percentage (cell B2). The percentage will be repeated in cell B6 and the remainder of 100% will be calculated in cell B5.
Create the Doughnut chart by selecting the data (cells A5 through B6) and insert a Doughnut chart (Insert (tab) -> Charts (group) -> Pie (category) -> Doughnut).
The result will appear something like the following chart.
Let’s Customize the Chart
Perform the following chart customizations:
- Remove the legend
- Customize the title to read “Progress Circle Chart v1”
- Remove the white borders of the colored arcs
- Change the color for “Remainder” from blue to light gray
- Change the color for “Percentage” from orange to blue
- Remove the chart border
We’re not quite ready to tackle the rounded edges.
To make the charted progress easier to understand, let’s add a textbox to the center of the chart to display the percentage value.
Chart Maker’s Pro Tip
When adding accents to a chart, like shapes or text boxes, select the chart prior to inserting the accent. By doing so, the accent becomes embedded in the chart and not just another floating object on the spreadsheet. The chart and the accent(s) now move and resize as a team instead of as separate elements.
Select the chart and insert a text box.
With the textbox selected (but NOT in edit mode; placing text inside the textbox), enter the following formula into the Formula Bar.
This will link the textbox to cell B2 and when the input percentage changes, the chart will automatically update.
With the textbox selected, perform the following cosmetic modifications:
- Increase the font size
- Center the text within the textbox
- Change the font style to “Arial Rounded MT Bold” (this will match thematically with our rounded edges in the chart)
- Change the color to blue (to match the color of the “Percentage” arc)
- Remove the textbox border
Time for Rounded Edges
This will be accomplished by customizing the borders of the “Percentage” arc.
Select the Doughnut chart and then select the blue arc so that “Percentage” is the only selected element in the chart.
In the Chart Options (CTRL-1 or double-click on the blue arc), select “Fill & Line” (paint bucket icon) and set the Border option to a Solid Line with the Color option set to the same blue color that the arc was set as. Set the Width of the border to something larger, like 13pts (you may need to experiment with this value to get the perfect look.)
This looks bulky and inelegant. To bring this back to something closer to our visual objective, select “Series Option” (chart icon) and set the “Doughnut Hole Size” to the maximum setting (90%).
This is a bit better, but the light gray arc representing “Remainder” is out of proportion to “Percentage.
Select the light gray arc so that “Percentage” is the only selected element in the chart.
In the Chart Options (CTRL-1 or double-click on the blue arc), select “Fill & Line” (paint bucket icon) and set the Border option to a Solid Line with the Color option set to the same light gray color that the arc was set as. Set the Width of the border the same value as the blue arc, 13pts.
If you wish to place more visual emphasis on the blue arc, reduce the width of the light gray arc by a few points.