How to create a Fragmented Circular Progress Chart in Excel 365?
Tags: createafragmentedcir
Published: 2021-08-19 04:53:40

---
title: How to create a Fragmented Circular Progress Chart in Excel 365?
published: true
date: 2021-08-12 17:02:07 UTC
tags: CreateAFragmentedCir
canonical_url: https://geekexcel.com/how-to-create-a-fragmented-circular-progress-chart-in-excel-365/
---

Have you ever tried to **Use the Bar Of Pie Chart** on your Excel sheet? Do you have any good methods for solving this task in Excel? Here I will introduce you to some quick tricks to deal with this problem. 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 a blank doughnut chart

- Firstly, you have to **enter the data** in the Excel Worksheet.
- For instances, you need to create the **survey details**.

![](https://geekexcel.com/wp-content/uploads/2021/08/survey-details.png)<figcaption>Survey Details</figcaption>

- Then, you have to click **anywhere on the sheet** and **insert a donut chart** and make sure that you have **not selected any data**.
- Now, you need to **insert the blank Donut Chart** in Excel Sheet.
- For that, you have to go to **Insert** tab and click on the **Donut Chart**.

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

## Add 10 equal data values to create a fragmented doughnut

- Firstly, to **create** an **equally divided doughnut chart** , you need to **add a data series** that have **equal values**.
- For that, you have to **right-click** on the **chart** area and click on **Select Data Option**.

![](https://geekexcel.com/wp-content/uploads/2021/08/click-on-select-data-3-1024x617.png)<figcaption>Click on the Select Data option</figcaption>

- Then, you need to click on the **Add** button in the **legend entries** segment.

![](https://geekexcel.com/wp-content/uploads/2021/08/Click-on-Add-button.png)<figcaption>Click on ADD button</figcaption>

- Now, you have to write **“Frags”** in the series name.
- After that, you need to **add 10 equal values** to divide the doughnut into **10 equal parts** , and you have to write **1 ten times in curly braces**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Enter-the-frags.png)<figcaption>Enter the series name and series value</figcaption>

- Finally, you will get the donut chart with data as given below.

![](https://geekexcel.com/wp-content/uploads/2021/08/Final-Donut-Chart-1024x413.png)<figcaption>Donut Chart with Data</figcaption>

## Color the doughnut in one color and reduce the hole size

- In the chart, all the **fragments of the chart** have different **colors** , and we need them to be the **same**.
- You have to **right-click** on the **doughnut chart** and click on the **format data series** option.

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

- Then, you need to choose **solid fill** from **fill and line** option.

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

- Now, you have to **reduce the whole size to 50%** from the **Series** Option.

![](https://geekexcel.com/wp-content/uploads/2021/08/click-on-reduce-the-transparency-1024x526.png)<figcaption>Click on Series Option</figcaption>

## Remove Chart Title and Legends

- You need to **remove the chart title,** and **legends** in the chart.

![](https://geekexcel.com/wp-content/uploads/2021/08/remove-the-chart-title-and-legend.png)<figcaption>Remove the Chart Title and legend</figcaption>

- Then, we need only the **area of the doughnut** , you have to make the **chart area into a square** by setting the **width and height of the chart area** to the **same size**.
- Now, you have to select the **chart area** and go to **Format menu** and then click on **Size** option.

![](https://geekexcel.com/wp-content/uploads/2021/08/Click-on-format-1024x411.png)<figcaption>Click on Format Menu</figcaption>

- After that, you need to set **height and width to 2**.

![](https://geekexcel.com/wp-content/uploads/2021/08/set-the-value-to-2-1024x501.png)<figcaption>Set height and width to 2</figcaption>

## Add Data series of the progress percentage

- Firstly, you need to **add the actual data series**.
- For that, you have to **right-click** on the **chart** and click on **Select Data** option.

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

- Then, you need to click on **Add** button in the **Legend Entries**.
- Now, in the **Series** values, you have to select **range A3:B3** and hit the **OK** button.

![](https://geekexcel.com/wp-content/uploads/2021/08/select-the-range-1-1024x464.png)<figcaption>Select the range</figcaption>

- After that, it **adds a new doughnut** to the chart and the **blue part shows the 20%** completion of the survey and orange shows the remaining part.

![](https://geekexcel.com/wp-content/uploads/2021/08/Final-result-1-1024x441.png)<figcaption>Adds new Donut chart</figcaption>

## Make the percentage series a secondary series

- You have to **right-click** on the any **data series** on the chart, and click on the **Change Series Chart Type** option.

![](https://geekexcel.com/wp-content/uploads/2021/08/click-on-change-on-the-change-series-chart-type-1024x479.png)<figcaption>Click on the Change Series Chart Type option</figcaption>

- Then, on **series 2,** you need to check the **secondary series** option.

![](https://geekexcel.com/wp-content/uploads/2021/08/Click-on-secondary-axis-1.png)<figcaption>Click on the secondary axis</figcaption>

- Now, it will make the **secondary series doughnut** cover the **first doughnut chart**.

![](https://geekexcel.com/wp-content/uploads/2021/08/final-op-sec-axis-1024x435.png)<figcaption>Secondary axis result</figcaption>

## Make the Completion Percentage Invisible

- You need to **double-click** on the **blue part of the chart**.
- Then, you have to go to the **format** option and click on **fill and border** option.
- Now, you need to choose the **No Fill** option.

![](https://geekexcel.com/wp-content/uploads/2021/08/Click-on-No-fill-option-1024x438.png)<figcaption>Click on the No fill option</figcaption>

- Finally, after selecting the **No fill** option, you will get the final result.

![](https://geekexcel.com/wp-content/uploads/2021/08/no-fill-result-1024x429.png)<figcaption>NO fill result</figcaption>

## Color the Remaining Series with Translucent White Color

- You need to **double-click** on the **Orange Part** of the chart.
- Then, you have to go to **Fill** option and choose **Solid Fill** option.

![](https://geekexcel.com/wp-content/uploads/2021/08/click-on-solid-fill-option-1024x458.png)<figcaption>Click on the Solid Fill option</figcaption>

- Now, you need to select **White or Black color** and adjust the **transparency to 50%**.

![](https://geekexcel.com/wp-content/uploads/2021/08/click-on-the-transparency-option-1024x466.png)<figcaption>transparency to 50%</figcaption>

- Finally, after **adjusting the transparency level** , you will get the final result.

![](https://geekexcel.com/wp-content/uploads/2021/08/adjusted-transparency-1024x424.png)<figcaption>Adjusted transparency chart</figcaption>

## Add a Text Box in The Center of The Chart and Show the Percentage there

- You need to **select the chart** and go to the **Format** option.
- Then, you have to click on the **Insert Shapes** option and select **Text Box.**

![](https://geekexcel.com/wp-content/uploads/2021/08/click-on-text-box-1024x526.png)<figcaption>Click on Text Box</figcaption>

- Now, you need to **drag it** in the **center** of the doughnut chart.
- After that, you have to click in the **formula bar** and give the reference of cell **A3**.

## Conclusion

In this tutorial, we guided you to know how to **Create A Fragmented Circular Progress Chart In Excel 365** 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/) **!!**

**Continue Reading:**

- **[How to Create Circular Progress Chart in Excel Worksheet?](https://geekexcel.com/how-to-create-circular-progress-chart-in-excel-worksheet/)**
- **[Excel Formulas to Generate Series of Date by Day ~ Easy Tricks!!](https://geekexcel.com/excel-formulas-to-generate-series-of-date-by-day/)**
- **[Formulas to Create the Series of Dates by Month ~ Simple Guide!!](https://geekexcel.com/excel-formulas-to-create-the-series-of-dates-by-month-simple-guide/)**
- **[Excel Formulas to Create a Series of Dates by Year ~ Complete Guide!!](https://geekexcel.com/excel-formulas-to-create-a-series-of-dates-by-year/)**
- **[How to add a secondary axis in Excel Office 365? – quick Tricks!!](https://geekexcel.com/how-to-add-a-secondary-axis-in-excel-office-365-quick-tricks/)**