Note: The other languages of the website are Google-translated. Back to English
Log in  \/ 
x
or
x
Register  \/ 
x

or

Create radial bar chart in Excel

In Excel, the radial bar chart evolves from the classical bar chart, it is also called as multilayered doughnut chart because of its layout as below screenshot shown. Comparing with the normal bar chart, the radial bar chart is displayed on a polar coordinate system, which is more professional and impressive for people, furthermore, it allows for a better use of space than a long bar chart. This article, I will talk about how to create this type of chart step by step in Excel.


Create radial bar chart in Excel

Supposing, you have a list of sale orders for each month as following screenshot shown, to create a radial bar chart based on these data, please do with the following steps:

First, create the helper column data

1. First, please insert a new blank row below the header row, and then type the following formula into cell C2, and press the Enter key to get the result, see screenshot:

=MAX(B3:B7)*1.3

2. Go on entering the below formula into cell C3, and drag the fill handle down to the cells to apply this formula, see screenshot:

=$C$2-B3

3. After getting the first helper data, then create the second helper data which is used as the data label for the chart, please enter the below formula into cell D3, and then drag the fill handle down to the cells for filling this formula, see screenshot:

=A3&", "&B3

Second, create the chart based on the data

4. Select the data range from A3 to C7, and then click Insert > Insert Pie or Doughnut Chart > Doughnut, see screenshot:

5. And a chart has been inserted into the sheet, now, select the chart, then click Switch Row/Column under the Design tab, see screenshot:

6. Then, you will get a chart as below screenshot shown:

7. Right click the doughnut and choose Format Data Series from the context menu, see screenshot:

8. In the opened Format Data Series pane, under the Series Options tab, choose the Doughnut Hole Size and set it to 25%. See screenshot:

9. And then, double click to select the outer ring (the orange ring), and then select No Fill from the Fill section under the Fill & Line tab, see screenshot:

10. Repeat the above step to fill No fill for the inner slices one by one, and all the orange slices are invisible, see screenshot:

11. Now, please double click to select the first blue slice and fill it with a color you like, and then fill other blue slices with different colors you need, see screenshot:

12. Then, you should add the data labels to the chart, please click Insert > Text Box > Draw Horizontal Text Box, and then insert a text box as you need, and then, select the inserted text box, and jump to the formula bar, type =$D$7 to create a linked cell to text box, see screenshot:

Note: D7 is the data label that you want to add to the chart, the slices of the chart are inverse with the data range, so, the last row of cell in the range is the outer ring’s data label.

13. Then repeat the above step to insert the text boxes for the other 4 slices and link with cell D6, D5, D4, D3 from outer to inner ring. And then, you can format the text box with no fill and no border as you need, then you will get the chart as below screenshot shown:

14. After inserting the text box, then hold the Ctrl key to select all the text boxes, and then right click, choose Group > Group to group the text boxes together, see screenshot:

15. Then, you should group the text box with the chart, press Ctrl key to select the text box and the chart arear, and then right click to choose Group > Group, see screenshot:

16. Finally, the radial bar chart has been created successfully, when moving the chart, the data labels will be moved as well.


Create radial bar chart in Excel with a handy feature

Kutools for Excel provides 50+ special types of charts that Excel does not have, such as Bullet Chart, Target and Actual Chart, Difference Arrow Chart and so on. With its handy tool- Radial Bar Chart, you can create a radial bar chart quickly and easily in Excel workbook. Click to download Kutools for Excel for free trial!

doc kte progress circle chart 1


Download Radial Bar Chart sample file


Video: Create radial bar chart in Excel


The Best Office Productivity Tools

Kutools for Excel - Helps You To Stand Out From Crowd

Would you like to complete your daily work quickly and perfectly? Kutools for Excel brings 300 powerful advanced features (Combine workbooks, sum by color, split cell contents, convert date, and so on...) and save 80% time for you.

  • Designed for 1500 work scenarios, helps you solve 80% Excel problems.
  • Reduce thousands of keyboard and mouse clicks every day, relieve your tired eyes and hands.
  • Become an Excel expert in 3 minutes. No longer need to remember any painful formulas and VBA codes.
  • 30-day unlimited free trial. 60-day money back guarantee. Free upgrade and support for 2 years.
Ribbon of Excel (with Kutools for Excel installed)

Office Tab - Enable Tabbed Reading and Editing in Microsoft Office (include Excel)

  • One second to switch between dozens of open documents!
  • Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
  • Increases your productivity by 50% when viewing and editing multiple documents.
  • Brings Efficient Tabs to Office (include Excel), Just Like Chrome, Firefox, And New Internet Explorer.
Screen Shot of Excel (with Office Tab installed)

Say something here...
symbols left.
You are guest
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.