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 an option to do it in a smart way. 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


Download Practice Workbook

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


Steps to Create a Radial Bar Chart in Excel

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 purpose and “Labeling” for labeling purpose:

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 Create a Bar Chart in Excel with Multiple Bars (3 Ways)


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 Make a Bar Graph with Multiple Variables in Excel


Similar Readings


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 showed 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 image) of the outermost circle. We can see from the image that this Orange part is representing the Column for 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 (3 Methods)


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 Create & Customize Bar of Pie Chart in Excel


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. Being said that, if you face any problem regarding this article or have any queries, please feel free to leave a comment in the comment box below, Exceldemy team will try to solve that for you. Have a good day!


Related Articles

Hadi Ul Bashar

Hadi Ul Bashar

I'm Hadi Ul Bashar, an Engineering aspirant. I always look forward to keeping myself up to date in my area of interest. Currently, I'm happy to work at Exceldemy as an Excel & VBA Content Developer. My goal here is to provide an easy and detailed solution to whatever problem you may face in Excel. I hope I will make your Excel life easy as I'm always open to solve new problem!

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo