How to Create a Radial Bar Chart in Excel (with Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

Suppose you are a product manager and want to compare the sale returns of your product in various outlets. Excel provides you with an option to do it in a smart way. A Radial Bar Chart in Excel helps you to visualize your data even better. In this article, I’m going to share the details about the Radial Bar Chart step by step so that you may use them whenever necessary. Let’s get a glimpse of what it looks like from this image:

How a Radial Bar Chart of MS Looks Like


Radial Bar Chart in Excel: with Easy Steps

Step 1: Preparing Dataset for Chart

In this example, we have the sales data of our product “iPhone 14 Plus” in the month of December 2022 in the outlets across six states named “California”, “Florida”, “Texas”, “New York”, “Arizona” and “Washington”. We’ll use the Radial Bar Chart to compare the sales data.

Steps:  

  • Our dataset looks like this:

Image of Dataset for Radial Bar Chart

  • Make two Columns named “Column for Comparison” for comparison purposes and “Labeling” for labeling purposes:

Column Creation

  • Type the following formula in cell D7 and Hit ENTER. This shows the output in cell D7.
=MAX(C8:C13)*1.4

This output is 1.4 times the maximum sell value. We’ll compare our sales according to this value. To know more about the MAX function.

Formula in cell E7

The output of the formula is:

Output of formula

  • Now, type the following formula in cell E8 and hit ENTER to get the difference between E7 and D8 :
=$E$7-D8

Formula in cell E8

  • The output looks like this:

Output in cell E8

  • Hold and Drag down the AutoFill icon from the bottom right edge of cell E8 all the way to cell E13. This will automatically imply the formula we’ve used in cell E8 and make necessary adjustments to all the cells from E9 to E13.

AutoFill column

We can see the output in the “Column for Comparison” column. We’ll get all the output in this way.

Output of AutoFill

Read More: How to Flip Bar Chart in Excel


Step 2: Compiling Chart from Dataset

In this step, we’ll generate a Doughnut Chart for our dataset. This is the core part of our task.

  • Select the range of cell C6:E13. After that, navigate to the “Insert” option and select the Doughnut Chart. I’ve attached a figure for your convenience.

Excel Radial Bar Chart Insert Option

  • Now we’ll customize the chart according to our use. Select the “Chart Area” to actively select the chart.

Chart Area

  • Now, Right Click on the Chart Area and select the Select Data option.

Select Data

  • A new window will open. Click the Switch Row/Column option. This will swap the row and column. Then click OK.

(Switch Row/Column)

Read More: How to Create a 3D Bar Chart in Excel


Step 3: Bar Chart Modification

At this stage, we’ll get a chart, but in a very basic mode. We need to modify it further to get the digestive format. I’ve shown the process here:

  • Place the mouse pointer on the Doughnut as I’ve shown in the image below and Right Click on it. Now, select Format Data Series... A new window will open.

Excel Radial Bar Chart No Fill Option

  • We’ll get the Doughnut Hole Size option on the Right Pane. Set the Doughnut Hole Size to 20%.

(Doughnut Hole Size)

  • Now. select the Orange portion (marked “1” in the image) of the outermost circle. We can see from the image that this Orange part represents the Column for the Comparison portion of the dataset. Follow my marking “2” and “3” to set the “No fill” option for this.

Excel Radial Bar Chart Format Chart Area

  • I’ll repeat the just-mentioned process for the other circles too. This outcome is like this:

(No fill)

  • Now, set different colors for the remaining portions of the circles according to your need (to better differentiate them). I’ve shown the process below for a single one.

Excel Radial Bar Chart Color Selection

  • I’ve repeated the above step for all the other slices. The output is :

Radical Bar Chart Color

Read More: How to Change Bar Chart Color Based on Category in Excel


Step 4: Data Modification for Labeling

We need to properly label the Doughnut Chart to get the right visualization. For this purpose, we will create labeling by combining the State name and Sales in USD($) of the corresponding rows and store them in corresponding cells.

  • We’ll set “Labeling” against all the slices. For this reason, type the following formula in the F8 cell and press ENTER.

(Formula in cell F8)

  • The output is :

(Output in cell F8)

  • Hold and Drag down the AutoFill icon from the bottom right edge of cell F8 all the way to cell F13. This will automatically imply the formula we’ve used in cell F8 and make necessary adjustments to all the cells from F9 to F13.

(Autofill)

  • AutoFill output looks like this:

(AutoFill Output)

  • Now, get a “Text Box” from the insert menu. This looks like this:

Excel Radial Bar Chart Textbox option

  • Now, we’ll link cell F8 to this “Text Box” by selecting the “Text Box” and writing the following formula to the Formula Bar.
=$F$8
  • The output shows that:

(Output of Text Box)

  • We’ll repeat the process for cells C9:C13 and place the Text Box against the slices. Keep in mind to set the Text Boxes in the order that they appear in the Doughnut Chart. Also, Group all six Text Boxes by selecting the Text Boxes while pressing the Ctrl key. We’ve shown the process below:

(Grouping)

  • The output looks like this:

Radical Chart Grouping

  • Similarly, the Text Boxs and the Doughnut Chart are grouped too. And The Title of the chart is also adjusted. The final output looks like the following

Final Glimpes of Radical Bar Chart

Read More: How to Make Floating Bar Chart in Excel


Download Practice Workbook

You can download the workbook containing the dataset from here that we’ve used throughout this article.


Conclusion

If you’re in this segment, I thank you for your interest in this content. I’ve demonstrated a detailed process of how to create a Radial Bar Chart in Excel. I hope you get the necessary solution. Having said that, if you face any problems regarding this article or have any queries, please feel free to leave a comment in the comment box below, and we will try to solve that for you. Have a good day!


Related Articles


<< Go Back to Create a Bar Chart in Excel | Excel Bar Chart | Excel Charts | 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.
Hadi Ul Bashar
Hadi Ul Bashar

Hadi Ul Bashar holds a BSc degree in Biomedical Engineering from Bangladesh University of Engineering and Technology.  In January 2023, Bashar joined SOFTEKO as an Excel and VBA content developer. Since then, he has authored over 50 articles. He was engaged in two specialized training programs focused on VBA and Chart & Dashboard designing in Excel. Currently he is creating video content on Excel and VBA and has created over 70 videos. Reading books and traveling are his... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo