Welcome to Excel Avon

3-D Progress circle chart in Excel

In today’s post we will show how to create 3-D Progress Circle Chart in Excel, yes it is a bit different, 3-D Progress Circle Charts have become very popular, but if you’re a beginner or need this type of chart for a project, you can save money on expensive software and create a 3-D progress circle chart in Excel. Its first iteration is a simple bar chart. A progress circle chart is a type of donut chart used in Excel to represent percentages completed to monitor progress toward a goal. It is more interesting and compelling than a progress bar chart. It is commonly used to show progress in news, business reports and even some software loading or refreshing.

In this article, I will teach you to create 3-D Progress Circle Chart in Excel step by step with pictures.

Well, as you can see, our 3-D Progress Circle chart is going to be like this.

3-D Progress Circle

Create 3-D Progress circle chart in Excel

Create a table in excel sheet which will look something like this. In which there will be 2 Values. Progress and Left Progress. Added formula for Left Progress =100%-C2.

Create 3-D Progress circle chart in Excel

Without selecting any data, insert a circle Hollow shape by going to insert tab> Illustrations> Shapes> Basic Shape > Select Circle Hollow.

Create 3-D Progress circle chart in Exce2

Drag the select shape in the sheet, yes many of you will think this is a doughnut chart which is not really it is a shape which looks like a doughnut chart.

Create 3-D Progress circle chart in Exce3

After drawing this chart, you can fix the shape manually from Size option.

Create 3-D Progress circle chart in Exce4

Right click on the chart then go to Format shape option.

Create 3-D Progress circle chart in Exce5

Now you have to do 3-D formatting of this shape. Go to 3-D format option and make the top bevel soft rounded. Increase the amount of width and height of the effect 3-D Effect.

Create 3-D Progress circle chart in Exce6

Now you have to do 3-D rotation, go to the 3-D rotation of the shape, then rotate the X rotation or rotation and Z rotation according to your accordion, you can see as the value is written below.

Create 3-D Progress circle chart in Excel52

Now our chart looks something like this

Create 3-D Progress circle chart in Excel10

Now we will insert 2-D Pie Chart by going to Insert tab. with selecting data.

Create 3-D Progress circle chart in Excel11

Now Delete the legend and chart title from the chart.

Create 3-D Progress circle chart in Excel12

Now you No Fill the background of chart also remove outline from the chart.

Create 3-D Progress circle chart in Excel13

Now select both the shape and the chart, then align it.

Create 3-D Progress circle chart in Excel14

Select the shape and chart and group them.

Create 3-D Progress circle chart in Excel15

Now Select the blue part and go to the format tab. And No Fill for the blue part with No outline.

Create 3-D Progress circle chart in Excel16

Now select the orange part and go to the format option and fill it solid and then fill this part with white color and make its transparency 25%.

Create 3-D Progress circle chart in Excel161

Go to insert tab and select it in the text box and drag it Center of the chart. remove the background and outline of the text box by going to the Format option with No Fill and No Outline.

Timer Chart in Excel 28

Add formula in Text Box =C2. after aligning the text box. Customize text box, Bold, size of font color, size of font.

Create 3-D Progress circle chart in Excel160

Select the shape and Textbox then group both.

Create 3-D Progress circle chart in Excel17

Go to view tab and remove gridline from chart.

Create 3-D Progress circle chart in Excel18

Now our 3-D progress Circle Chart in Excel. change the value of cell then you can see chart has been changed.

Create 3-D Progress circle chart in Excel20

Therefore, I hope that you have understood How to Create 3-D progress Circle Chart in Excel, maybe if you do not understand anything, then you can comment us with the question, which we will answer soon and for more information, you can follow us on Twitter, Instagram, LinkedIn and you can also follow on YouTube.

DOWNLOAD USED EXCEL FILE FROM HERE>>

LEARN MORE DASHBORAD AND CHART TOPIC HERE

You can also see well-explained video here about How to Create 3-D progress Circle Chart in Excel