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

Get FREE Advanced Excel Exercises with Solutions!

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.

Creation of Dataset with Proper information to create concentric circle chart in Excel

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

Creation of Dataset with Proper information to create concentric circle chart in Excel


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.

Insertion of Oval Shapes to Create Concentric Circle Chart in Excel

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

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

to Create Concentric Circle Chart in Excel

  • 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.

Insertion of Oval Shapes to Create Concentric Circle Chart in Excel

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

Insertion of Oval Shapes to Create Concentric Circle Chart in Excel

Read More: How to Draw a Circle in Excel with Specific Radius 


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.

Coloring and Editing of Chart to Create Concentric Circle Chart in Excel

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

Coloring and Editing of Chart to Create Concentric Circle Chart in Excel

  • 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.

Coloring and Editing of Chart to Create Concentric Circle Chart in Excel

  • 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?

concentric circle chart excel

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.


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.


Related Articles


<< Go Back to Circle in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Wasim Akram
Wasim Akram

Wasim Akram holds a BSc degree in Industrial and Production Engineering from Ahsanullah University of Science and Technology. Over the past 2 years, he has been actively contributing to the ExcelDemy project, where he has authored more than 150 articles. Now, he is working as an Excel VBA and Content Developer. He likes learning new things about Microsoft Office, especially Excel VBA, Power Query, Data Analysis, and Excel Statistics. He is also very interested in machine learning and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo