Stuck with old and boring ways of presenting data in Excel? Well, not anymore.
Creating visually appealing and stunning data presentations in Excel can help you take your data to the next level.
3D progress circles are one of the best and most intuitive ways to track sales targets, project milestones, and to measure any other metrics in Excel.
3D progress circles help you leave a long-lasting impression on your bosses, co-workers, and audience.
In this article, we will learn one of the best and most compelling ways to showcase progress data in Excel: a 3D progress circle.
With no further delay, let’s dive into today’s topic on how to create a stunning 3D circle in Excel.
What Is A 3D Progress Circle In Excel?
A 3D progress circle is a specialized chart that is formed by combining a pie chart and a doughnut chart.
The 3D progress circle in Excel is used to visualize progress towards specific goals such as tracking sales targets, and project milestones, and to measure any other metrics in Excel.
A 3D progress circle involves a combination of both a pie chart and a doughnut chart. Rest done using format options in Excel.
What Are The Uses Of 3D Progress Circle In Excel?
3D progress circles in Excel are used for various reasons. Here are some of the reasons for using 3D progress circles in Excel.
Visualizing Progress
The 3D progress circle in Excel is used to provide clear and engaging insights to show or track progress toward specific goals.
Enhanced Your Dashboard
3D progress circles in Excel allow you to enhance your dashboard by creating and adding visually appealing dynamic progress indicators.
Create Dynamic Reports
3D progress circles not only allow you to create progress indicators but also help you create stunning and easy-to-read reports.
These dynamic reports help you better communicate the data in your reports.
Interactive Presentation
3D progress circles can be used in presentations to provide real-time progress updates in Excel.
These dynamic progress indicators and circles also help you keep your audience and team members engaged and active.
Tutorial On How To Create 3D Progress Circle In Excel?
Let’s learn how to create a 3D progress circle in Excel using demo data.
Follow these steps in Excel to create a 3D progress circle.
- As you can see, there are three tasks that we will be doing in this tutorial to understand the function and uses of 3D progress circles in Excel.
- Task 1 is to create a progress circle showing the performance percentage of the employees which is 80% out of 100.
- Task 2 is to create a progress circle showing the quality of work which is 60% out of 100.
- Task 3 is to create a progress circle showing productivity which is 40% out of 100.
- The metric for target completed is out of 100. So the first thing that we need to do is mention it in the formula.
- To mention the metric is the target, simply put “=100%-C1” and press enter.
- As you can see, the 20.0% target is remaining out of 100%.
- As you can see, it is showing 20.0%, to remove the decimal all you need to do is, go to the Home tab, look for the option “Number Group” and click on the option Decrease decimal.
- As you can see the decimal has now been removed.
- Do this for the rest of the data and your data should look like this.
- Now we have completed the task of creating data, it’s time to move forward with our topic of creating 3D progress circles in Excel.
- To create dynamic progress circles, we first need to insert a shape. For my task, I’ll be using a “Circle Hollo or Donut” shape.
- As you can see, we now have a shape but if you notice carefully, it doesn’t look like a circle. So to fix this problem we will delete this shape.
- To draw the perfect circle press the “Shift” key on your keyboard and draw the shape while holding the Shift key on your keyboard and you will have a perfect circle.
- Now you can format your shape as per your requirement using the format tab on your computer.
- In my case, I don’t need the outline so, I’ll simply remove the outline from my shape using the format tab.
- To remove outlines from your shape, select the shape, go to the format tab, now look for the option Shape outline, and click on the No outline option.
- Also, keep in mind that if you want to decrease or increase the size of your circle shape you need to do it while holding the shift key, otherwise you will lose your perfect circle and you will have to start all over again.
- If you want to set the maximum and minimum height and width of your circle, you can also do that.
- Just click on your shape, go to the format tab, and on the last right corner you will find the shape group where you can set the width and height of your shape.
- Now, to change the color of your shape, simply go to the format tab, look for the option shape fill, and select the color you want for your circle.
- Now what we need to do is convert this 2D circle into a 3D circle.
- To convert your 2D circle into a 3D circle, simply click on your circle, go to the Shape Effects option, select 3D rotations, and select the style and effect you want for your circle.
- These effects are provided by Excel and in case you want to change and create an effect as per your requirements, you can do that too by using the 3-D Rotation Option.
- After you click on the 3-D Rotation Option a new “Format Shape” dialog box will appear on the right side of your screen.
- This dialog box is also called the Task pane.
- Let’s format our circle using this Task pane. The first option we will be using to format our circle is the 3-D format.
- Select the shape, go to the Format Shape dialog box, and click on the 3-D format option.
- After you click on the 3-D Format option you will see many effects that you can add to your shape.
- In my case, I’ll be using the Top Bevel effect for my circle.
- This is how your circle would look after you select the Top Bevel effect.
- Now, if you want to change the width and height of the circle directly from the Task pane.
- Now let’s also explore the 3-D rotation option in the Task Pane to further format our circle and make it stunning.
- In the 3-D rotation option in the Task pane, you will find options such as X rotation, Y rotation, and Z rotation.
- These are used to give a 3-D rotation effect to your shape.
- As you can see I have used the 340* rotation effect for both X & Y and 50* for Z rotation.
- Now when we have converted our shape from 2D to 3D, let’s see how we can add data into it.
- To add data into this shape we first need to insert a chart for our data.
- To insert a chart for your data you first need to select the data range, then go to the Insert tab, click on the chart group option, and select the 2-D Pie chart.
- Now, let’s see how you can increase the size of your pie chart from the inside.
- To increase the size of your pie chart from the inside, all you need to do is remove the things that you don’t need in your pie chart.
- To remove the title and legend or data labels from your Pie chart, all you need to do is uncheck them.
- We can also remove the background color of our Pie chart. To remove the background color of your Pie chart, simply click on your Pie chart, go to the format tab, select the Shape Fill option, and click on the No Fill option.
- Now, I also don’t need the blue portion, so I’ll simply remove it by double-clicking on the blue portion and then go to the format tab, select the option shape fill, and click on the No fill option.
- Now, we need to put that pie chart in the center of our circle. And to do that we need to select the circle and the chart.
- After selecting the circle and the chart go to the format tab, go to Arrange groups, and click on the Align option, from the drop-down menu click on Align Center.
- This is how your circle and chart would look after you click on the Align Center option.
- After the center alignment, we also need to Align it in the middle.
- To do that all we need is to click on the option Align Middle from the drop-down menu in the format tab in the arrange group.
- The next step is to group them so that we don’t lose the alignment we just made.
- Go to the format tab, look for the arrange group, click on the Group option, and select the option Group.
- Now we need to select the pie chart area, to do that you need to double-click on it.
- After selecting the pie chart you will have a new dialog box appear on the right side of your screen.
- Click on the Fill & Line option, select Solid Fill, select the color, and set transparency as per your need, I am keeping my transparency to 25%.
- This is it, we have now created a dynamic 3-D progress circle.
- You can now follow the steps mentioned in the article to create a 3-D progress circle for the 2nd and 3rd tasks.
Bottom Line
Creating visually appealing and stunning data presentations in Excel can help you take your data to the next level.
3-D progress circles are best for creating engaging and visually appealing intuitive reports and presentations.
I hope you find this article helpful and learn something good and interesting that will help take your data presentation game to the next level.
Also Read
- How To Create Dynamic Charts In Excel In 2024
- A Guide On How To Use Copilot In MS Word
- 8 Most Useful & New Excel Formulas In 2024
- 5 Best Features Of Google Sheets In 2024