Welcome to Excel NaNa
This clip will show "How to create Infographic Progress Chart in PowerPoint"
This chart will be created by Chart object
Not created by Shape or Drawing
This is the result from creating a chart object
Except the value is a textbox
What are the benefits of chart object?
Easier for editing data or the scale
For shapes, you need to select and change color
For chart object, when you need to change the value
by right click, then select Edit Data
The Excel like dialog will be shown
Change the data in cell C2
The chart will automatically updated as the data change
In case you want to change the number of scales
Now, there are 20 slots of scale
If you want to change the number scale to be 12
You can change the data in column B
So the number of scale will be changed
It also easily change color in chart object
by right click at chart, then select Format Data Point...
then change the fill color
Let see the steps of how to create this chart
Let start from zero
First, select Ribbon Insert, then select Doughnut Chart
By default, it will show some data
I ignore the label data in column A
Then delete them
In column B, I make it as Scale data
Let make the scale with 12 slots
Then input number 1 in B2 to B13
Input 1 in B2, then copy to B3 to B13
Let check the chart
Next step,
I will add Value data
Let make the chart show value of 65%
Input 65 in C2, there is more doughnut appears
Next, make the new doughnut show as 65% by add more data
For 100% as maximum data
Let add 35% left
By add a formula in C3 as  "=100 - C2"
As I use formula, when change the value,
the left will be automatically changed
Now, our data if ready
Next, modify the look of the chart
Delete legend
Let modify the scale
right click, select Format Data Series...
Select the whole series, change the Fill Color
--- I will update the Subtitle soon ---
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
