At work , There are often various indicators of the completion rate , use Excel Make an instrument diagram , It shows the completion rate intuitively , It can also be inserted into PPT I'll give you a presentation .
for example , Our current mission completion rate is 77%, It can be made into the following effect , As shown below ：
1、 Prepare the data
The data of completion rate is put in D2 Cell , And then in A Column sum B The columns are inserted into the auxiliary columns respectively
A The data for the column is 30,30,30,30,30,30,180
B2 The formula for a cell is ：=ROUND(D2*100,0), Multiply the completion rate by 100, then 4 House 5 I want to get rid of the decimal point
B3 Fixed content 2,B4 The content is 200-B2-B3
2、 choice A Columns of data , Insert a doughnut
Double click on the doughnut , Change the starting angle of the first sector of the series to 270 degree .
Then click the shape of each doughnut in turn , Change each shape to a different color adjustment , The bottom one is white , Or no fill .
3、 choice B Columns of data , Insert pie chart
The starting angle of the first sector is also changed to 270 degree
Click on two large sectors , Fill in the color as no fill
Select the whole chart , Change the background of the chart to unfilled , And then it overlaps with the torus .
4、 Insert a text box , Change the font to impact typeface , Enter the formula in the formula edit bar =D2, Bound the original completion rate data
So a chart is made , To put these charts together , Select an element , Press CTRL+A key , And then it's just a combination , When dragging , It's going to drag as a whole .
Have you learned ？ Let's try it , It doesn't matter what you don't learn , Private message reply materials , You can change the completion rate directly , The chart can be used directly .
Welcome to your attention , More exciting content is constantly updated ...