How to Create Circular Progress Chart in Excel Worksheet?
Tags: tocreatecircularprog
Published: 2021-08-18 12:55:15

---
title: How to Create Circular Progress Chart in Excel Worksheet?
published: true
date: 2021-08-11 16:48:41 UTC
tags: ToCreateCircularProg
canonical_url: https://geekexcel.com/how-to-create-circular-progress-chart-in-excel-worksheet/
---

 **Progress Bars** are simple graphics that can be quite visually powerful by instantly providing detail to your audience on how close your team might be to completing a **goal or task**. In this tutorial, we are going to see the formulas to **create a Circular Progress Chart In Excel Worksheet**. Let’s get them below!! Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

## Insert Data

- Firstly, you have to **enter the data**.
- For instance, you need to create a **process details**.

## Select B2:C2 and Insert a Donut Chart

- You need to select the **data A2:B2**.
- Then, you have to go to the **Insert** tab.
- Now, you need to click the **Donut Chart** under the **Chart** section.

![](https://geekexcel.com/wp-content/uploads/2021/08/click-Doughnut-chart.png)<figcaption>Click Donut Chart</figcaption>

- After **selecting the Donut Chart** , you will get the result as given below.

![](https://geekexcel.com/wp-content/uploads/2021/08/Donut-Ex.png)<figcaption>Final output</figcaption>

## Delete Non-required elements & adjust the width of the chart area

- Firstly, you have to **delete** the **legends and chart titles** from the chart.
- Then, our chart needs only the **space of the circle** , so you need to **reduce the width** into a **square shape**.
- Now, you can **adjust the width and height of the chart** from the **format** menu of the chart.

![](https://geekexcel.com/wp-content/uploads/2021/08/Adjust-the-width-and-height.png)<figcaption>Adjust the Width and Height</figcaption>

## Add Border to Donut Chart

- You need to **add a border** to the whole **donut chart**.
- For that, you have to **select the donut** and **right-click** on it.
- Then, you need to click on the **format data series** option.

![](https://geekexcel.com/wp-content/uploads/2021/08/Click-on-Format-Data-Series-Option-1.png)<figcaption>Click on Format Data Series Option</figcaption>

- Now, you have to go to **fill and border** and click on **Border** option and then choose **solid line**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Click-on-Border-option.png)<figcaption>Click on Border Option</figcaption>

## Change the fill color to same color of the border

- You need to go to **fill option in formatting** and select **solid fill**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Click-solid-color-1024x497.png)<figcaption>Click on Solid color</figcaption>

- Now, you have to choose the **same color** as the **border**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Click-border-color-1024x501.png)<figcaption>Click border-color</figcaption>

## Reduce the Transparency of the Remaining part

- You need to **double-click** on the **remaining part** and go to **formatting** and **reduce the transparency to 50%**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Reduce-the-Transparency-1024x498.png)<figcaption>Reduce the transparency to 50%</figcaption>

- Now, this will make the **chart** look like a **fill-in oval progress chart**.

## Add Text Box in the Center of the Progress Chart

- Firstly, you have to go to the **Insert tab** and then click **Text Box**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Click-Text-Box-1024x462.png)

- Then, you need to click on the **text box option** and **add it to the center of the donut graph**.
- Now, you have to **Link it to the cell A3**.
- To **link** , you need to select the **Text Box** , and **click-in formula bar** and then give **reference to cell A3**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Link-the-cell.png)<figcaption>Link the cell</figcaption>

## Clear the background of the progress chart and make it no fill

- You need to **select the chart** area and go to **fill** in the **formatting option** and select **No fill** for the chart area.
- Now, for the **border** , you have to select **no border**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Click-on-fill-and-broder.png)<figcaption>Click on no fill and no border</figcaption>

## Summary

In this tutorial, we guided you to know how to **create a Circular Progress Chart In Excel Worksheet** with proper examples and screenshots. Kindly, give your **feedback** in the below comment section.

Thanks for visiting **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Keep Reading:**

- **[How to copy and paste chart formatting in Excel 365?](https://geekexcel.com/how-to-copy-and-paste-chart-formatting-in-excel-365/)**
- **[Creating Quarterly Sales Chart by Clustered Region in Excel 365!!](https://geekexcel.com/creating-quarterly-sales-chart-by-clustered-region-in-excel-365/)**
- **[Charts with floating up-down bars in Excel 365 – Easy Tricks!!](https://geekexcel.com/charts-with-floating-up-down-bars-in-excel-365-easy-tricks/)**
- **[Excel Formulas to Find the First Row Number ~ Useful Tutorial!](https://geekexcel.com/excel-formulas-to-find-first-row-number/)**
- **[Excel Formulas to Find the Last Position in Mixed Data with No Blanks!!](https://geekexcel.com/excel-formulas-to-find-the-last-position-in-mixed-data-with-no-blanks/)**