Use Excel to make an instrument chart, intuitively show the completion rate, 1 minute to learn!
Lanmeng Fengxi 2021-02-23 03:23:33

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 :

 use Excel Make an instrument diagram , Visual display of the completion rate ,1 Minutes to learn !


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

 use Excel Make an instrument diagram , Visual display of the completion rate ,1 Minutes to learn !


2、 choice A Columns of data , Insert a doughnut

 use Excel Make an instrument diagram , Visual display of the completion rate ,1 Minutes to learn !


Double click on the doughnut , Change the starting angle of the first sector of the series to 270 degree .

 use Excel Make an instrument diagram , Visual display of the completion rate ,1 Minutes to learn !


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 .

 use Excel Make an instrument diagram , Visual display of the completion rate ,1 Minutes to learn !


3、 choice B Columns of data , Insert pie chart

 use Excel Make an instrument diagram , Visual display of the completion rate ,1 Minutes to learn !


The starting angle of the first sector is also changed to 270 degree

 use Excel Make an instrument diagram , Visual display of the completion rate ,1 Minutes to learn !


Click on two large sectors , Fill in the color as no fill

 use Excel Make an instrument diagram , Visual display of the completion rate ,1 Minutes to learn !


Select the whole chart , Change the background of the chart to unfilled , And then it overlaps with the torus .

 use Excel Make an instrument diagram , Visual display of the completion rate ,1 Minutes to learn !


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

 use Excel Make an instrument diagram , Visual display of the completion rate ,1 Minutes to learn !


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 .

 use Excel Make an instrument diagram , Visual display of the completion rate ,1 Minutes to learn !


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 ...

版权声明
本文为[Lanmeng Fengxi]所创,转载请带上原文链接,感谢
https://fheadline.com/2021/02/20210223024051256P.html
相似文章

2021-08-09