Skip to main content

Create radial bar chart in Excel

Author: Xiaoyang Last Modified: 2021-02-23

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

🤖 Kutools AI Aide: Revolutionize data analysis based on: Intelligent Execution   |  Generate Code  |  Create Custom Formulas  |  Analyze Data and Generate Charts  |  Invoke Kutools Functions
Popular Features: Find, Highlight or Identify Duplicates  |  Delete Blank Rows  |  Combine Columns or Cells without Losing Data  |  Round without Formula ...
Super VLookup: Multiple Criteria  |  Multiple Value  |  Across Multi-Sheets  |  Fuzzy Lookup...
Adv. Drop-down List: Easy Drop Down List  |  Dependent Drop Down List  |  Multi-select Drop Down List...
Column Manager: Add a Specific Number of Columns  |  Move Columns  |  Toggle Visibility Status of Hidden Columns  Compare Columns to Select Same & Different Cells ...
Featured Features: Grid Focus  |  Design View  |  Big Formula Bar  |  Workbook & Sheet Manager | Resource Library (Auto Text)  |  Date Picker  |  Combine Worksheets  |  Encrypt/Decrypt Cells  |  Send Emails by List  |  Super Filter  |  Special Filter (filter bold/italic/strikethrough...) ...
Top 15 Toolsets12 Text Tools (Add Text, Remove Characters ...)  |  50+ Chart Types (Gantt Chart ...)  |  40+ Practical Formulas (Calculate age based on birthday ...)  |  19 Insertion Tools (Insert QR Code, Insert Picture from Path ...)  |  12 Conversion Tools (Numbers to Words, Currency Conversion ...)  |  7 Merge & Split Tools (Advanced Combine Rows, Split Excel Cells ...)  |  ... and more

Kutools for Excel Boasts Over 300 Features, Ensuring That What You Need is Just A Click Away...

Description


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, Edge and Firefox.
Comments (2)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
Hello

What’s the use of 1.3 in this formula =MAX(B3:B7)*1.3?
This comment was minimized by the moderator on the site
Hello, Ludo,

MAX(B3:B7): This part of the formula calculates the maximum value within the range B3 to B7. Essentially, it finds the largest value in the specified range.

*1.3: This part multiplies the maximum value by 1.3. The purpose of multiplying by 1.3 is to provide some extra space in the chart. By multiplying by a value larger than 1, you're essentially extending the range of the radial bar chart beyond the maximum value in the data set. This ensures that the bars in the chart have enough space around them and are not constrained to the exact maximum value. It helps in providing better visualization by avoiding the bars touching the edge of the chart area.

So, in summary, multiplying the maximum value by 1.3 in the formula helps create a buffer or padding around the bars in the radial bar chart to ensure better visualization and presentation of the data.
There are no comments posted here yet
Leave your comments
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations