How to Create Concentric Circle Chart in Excel (with Easy Steps)

We often create various types of charts to make our final report more lucrative and appealing. A concentric circle chart is one of them that we often use in our last report to present our data table in a different way. Creating a concentric chart in Microsoft Excel might seem difficult to you. Today, in this article, I am sharing with you how to create a concentric circle chart in Excel. Stay tuned!

Concentric Circle Chart in Excel: 3 Easy Steps to Create

In the following, I have explained 3 quick and simple steps to create a concentric circle chart in Excel.

Step 1: Creation of Dataset with Proper information

Let’s begin with creating our dataset. Suppose we have a company’s “Process Name” in our hands. Now we will create a concentric chart using some simple tricks.

Create another table where we will put the “Time Needed” for each process.

Next, to complete our dataset we will put a header at the top of the dataset.

Step 2: Insertion of Oval Shapes for Concentric Circle Chart

As we have our dataset with proper information, let’s move on to create the concentric circle chart by inserting shapes.

First, choose the “Oval” shape from the “Shapes” option.

Second, draw a shape according to your choice inside the worksheet.

Hence, selecting the newly created shape press CTRL+C to copy.

Thereafter, click CTRL+V to paste and you will get to see another oval shape made just side by side with the previous one.

Then, reshape the shapes inside the previous one.

Similarly, we will create multiple circles according to our data table inside the workbook.

Step 3: Coloring and Editing Chart

As we have finished creating and re-arranging our created circles in the previous step. In this last step, we will color and edit circles to complete our concentric circle chart in Excel.

Simply, choose a circle and select your desired color from the “Home” ribbon.

Similarly, color other circles and your chart will look like the following image.

Next, we will insert “Text Box” from the “Insert” feature to name the processes.

Just, draw your own box inside the worksheet.

Then, put your desired process names from the data table.

Thereafter, connect the text box and circle with a “LineArrow”.

In the same fashion, create text boxes for other processes and connect them with multiple circles.
Here we have successfully created our concentric circle chart in Excel. Simple isn’t it?

Read More: How to Draw a Mohr Circle in Excel

Things to Remember

To create circle charts, you can also insert a “StackedVenn” chart from the “SmartArt Graphic” option.

Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.

Concentric Circle Chart.xlsx

Conclusion

In this article, I have tried to cover all the steps to create a concentric circle chart in Excel. Take a tour of the practice workbook and download the file to practice by yourself. I hope you find it helpful. Please inform us in the comment section about your experience. Stay tuned and keep learning.

<< Go Back to Circle in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!