Infographics: Progress Circle Chart in Excel

Welcome back my name is Priyender Kumar and today we will learn how to create this progress circle graph in Microsoft Excel. As you are seeing my screen I have created these three progress circles for displaying service level productivity and sales conversion and these graphs are connected with this data table. If I will change the value of service let's say 65 percent then this graph will be changed accordingly. Similarly for the productivity if I will change as 45 or the sales conversion I'll take as 13 then the value will be changed accordingly. So I will tell you how can you create this beautiful progress circle graph in Microsoft Excel. Let's start I'm copying this data table and going to add a new worksheet here and just paste the value here ctrl v. Okay so we will create the graph on this sheet. First of all I'm taking a support column as 1 minus v2 and just fill it down ctrl d. Now what I will do I'll go to the insert and I will insert a donut chart. So I'll go to the chart and we'll select this donut chart click on this. Now I will change the height and width of this donut chart as 2 by 2. So I'll take 2 and here can 2. Okay friends now what we will do we will add the data for this donut chart. So I'm going to I'm clicking right click and select data and add data series. So I will add under this curly bracket 20 times 1. 1 is already there 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20. Press ok. Let's check it's 20. Click on ok. Now what I will do I will go to this chart elements and remove chart title and legends. Now we can make it slightly bigger. Now right click on this donut go to the format data series and under format data series donut hole size. Currently it is 75 percent. We will change as 65 percent. Okay friends now what I will do I will go to the fill option here I will take the solid fill and I will fill it as this which is blue accent one darker 25 percent. Okay now what I will do I will go to the select the chart area and go to the format and here I will fill as no fill and shape outline is no outline no fill. Okay now what I will do I will copy this graph and paste it here. I'll make another copy here and for the second graph we will click on this and go to the fill option and we'll change the color let's say as green. For the third graph click on this and go to the fill option change the color as this orange. Okay friends now what I will do so the outline has not removed here so we'll go to the format and shape outline as no outline. Okay it's removed fine so now what we will do we will create the first graph for the service level click on this graph and go to the select data and go to the add data series series name will be the service level and the series value will be b2 to c2 click okay. Okay now right click on the this donut and go to the chain series chart type and here we will select service level secondary axis. Okay now what we will do we will double click on this blue part and we'll go to the format data points and here we will select the fill and line option and we will go to we will select the fill as no fill for the blue one and for the now we will double click on the orange and we will select the solid fill for solid fill we will take as white color and the transparency we will take as 20 percent. Now this graph is ready same thing we will do for the second graph right click select data add data series series name will be the productivity this time and the series value will be b3 to c3. Okay now right click on this donut and click on chain series chart type and select secondary axis for productivity now double click on the blue part and fill as no fill double click on the orange part fill as solid fill the white one already selected and transparency as 20 percent. Similarly for the third graph right click select data add data series series name sales conversion and the series value will be v4 to c4. Okay okay double click sorry right click on this outside donor and change series chart type and sales conversion as secondary axis now double click on this blue part fill as no fill sorry it was not selected let's undo double click on the blue part and no fill yes now double click on the orange part select solid fill and the fill as white transparency as 20 percent. Now all the three chart has been created now what we will do we will put a data level to putting the data level what I am doing going to the insert and I am selecting text box from here drag the text box here now go to the formula bar press equal to I will select the performance of the service level as 65 percent which is on v2 just make the alignment as center now we will change the font size as 30 and the font name as impact now we will go to the format under format we will use safe fill as no fill shape outline as no outline now we'll go to the home and change the font color as the same color which we have taken for the graph one and we can put it here now just copy this and paste again we can put it here paste again you can put it here now what we will do we will change the value as v3 for the productivity similarly for this we will change the value as v4 now format has been changed for this so what we will do we will select the first text box and go to the format painter and just click here now again go to the format painter and just click here now we will change the select the second one and change the font color we'll take the green one similarly for this we will take the font color as orange now we will create another copy of this and we will put it here and we will select here a2 for the service level this time we will take font name as arial and the size as 12 just make it bold then change the color as the same color or we can take the font size 16 let's say let's put it here copy this and paste it here this time we will use a3 just paste it here and a4 now similarly we will select the first one go to the format painter click here format painter click here we'll change the color for this as green for this as orange now we will go to the view and remove the grid lines headings and select this support column and you can fill it as white and graph is ready you can check this let's say change the service level as 95 percent productivity as 68 percent the sales conversion at let's say 34 percent so it's working fine so friends that is how you can create this graph in microsoft excel i hope you have enjoyed this video thank you so much for watching