Astra

Create a Radial Stacked Bar Chart in Excel with Examples – Download Free Templates

Estimated reading: 4 minutes
Create a Radial Stacked Bar Chart in Excel free template

Estimated reading: 3 minutes

Bulky data is visually represented in a traditional bar chart by stacking it vertically or horizontally, one on top of the other. But you are choosing a traditional way—the “Radial Stacked Bar Chart“—to represent your data. In a radial stacked bar chart, data will be visualized on a circular or polar coordinate system and separated by colorful contrast.

Microsoft Excel provides no built-in system to create a radial stacked bar chart. But we will create a radial stacked bar chart with the help of a type of Pie chart-” Doughnut Chart”

CLICK HERE TO DOWNLOAD THE TEMPLATE

Suppose you are given a table containing the selling quantities of five different products. And you want to create a radial stacked bar chart with the data.

Steps to Create  Radial Stacked Bar Chart in Excel

Step 1: Prepare Data for Creating a Radial Stacked Bar Chart.

Step 1.1: Insert a new column named Helping data and input the following formula in the output cell D3

=MAX(C$3:C$7)*1.3-C3
Create a Radial Stacked Bar Chart in Excel

Step 1.2: Press Enter and AutoFill the remaining cells in column D

Create a Radial Stacked Bar Chart in Excel 1

Step 2: Create a Data Label for Each Circle of the Radial Bar Chart

Step 2.1: In a new column, insert the following formula in the output cell E3

=B3&"-Q"&TEXT(C3,"00%")
Create a Radial Stacked Bar Chart in Excel 2

Step 2.2: Hit the Enter Key and AutoFill the remaining empty cells in column E

Create a Radial Stacked Bar Chart in Excel 3

Step 3: Select the data range B3:D7.

Step 4: Click on the “Insert” tab. 

Step 5: Next, choose the doughnut chart from the pie chart section.

Create a Radial Stacked Bar Chart in Excel step

The chart will appear on the sheet.

Create a Radial Stacked Bar Chart in Excel 7

Step 6: Double-click on the chart.

Step 7: The chart design tab will be displayed. Click on the switch row /column option from the chart design tab.

Create a Radial Stacked Bar Chart in Excel steps 2

Then, the chart will alter its elements as shown below

Step 8: Click on the doughnut area and then right-click on the mouse. and then select the Format Data Series option.

Create a Radial Stacked Bar Chart in Excel with Examples

Step 9: Format Data Series tab will be opened from the right side of your monitor. Set the doughnut hole size at 25%, as marked in the picture below.

Create a Radial Stacked Bar Chart in Excel with Examples2

After pressing Enter, the result will be:

Create a Radial Stacked Bar Chart in Excel with Examples Templates

Step 10: Delete the orange portion of the radial bar chart.

Step 10.1: Double-click on the outer ring or circle of the chart. 

Create a Radial Stacked Bar Chart in Excel with Examples 76

Step 10.2: From the Format Data Series tab, select the No Fill option.

Create a Radial Stacked Bar Chart in Excel with styling

Step 11: Repeat Step 10 for all the circles in the chart. And the result will be as below:

Create a Radial Stacked Bar Chart in Excel template download

Step 12: Change the chart’s color.

Step 12.1: Double-click on the blue side of the chart. 

Step 12.2: The Format Data Point tab will be opened.

Step 12.3: From the Theme color option you can change the color for every circle individually 

Create a Radial Stacked Bar Chart in Excel 2010

See the following color change result:

Create a Radial Stacked Bar Chart in Excel result

Step 13: Placing chart labels

Step 13.1: Go to the “Insert” tab. 

Step 13.2: Click the “Text” button.

Step 13.3: Click on the “Text Box” option. Place it in the appropriate position.

Step 13.4: Now, In the formula bar input the following formula to link the text box with cell E8

=$E$8

Step 13.5: Repeat step 13.1-13.4 for all circles of the chart

Create a Radial Stacked Bar Chart in Excel labeling

Note: You can omit Step 13 if you write the names of the products manually in the Text Box.

Final Result:

Create a Radial Stacked Bar Chart in Excel with Examples Free Templates

12 thoughts on “Create a Radial Stacked Bar Chart in Excel with Examples – Download Free Templates”

  1. signer

    Hаve you ever consideｒed writing an ebook or guеst authoring on other sites?
    I have a blog baѕed upon on the same ideas you discuss and would love to have you ѕhaгe some stoгies/information. I know my
    viewers would appreciate your work. If you’re even remotely
    interested, feｅl free to shߋot me an email.

    Reply
    1. Nil Ratan

      I’m glad my writing style was valuable to you. I’m incredibly committed to and enthusiastic about writing for SOLVED EXCEL. I wonder whether I was able to find some time to work with you. You know it’s tough for a student to manage so much time. I’ll be grateful to accept your offer when I’m able to.

      Reply
  6. buy instagram followers free

    It’s a shame you don’t have a donate button! I’d most certainly
    donate to this outstanding blog! I suppose for now i’ll settle
    for bookmarking and adding your RSS feed to my Google account.
    I look forward to new updates and will share this blog with my Facebook
    group. Talk soon!

    Reply
  8. buy tiktok followers with gift card

    It is perfect time to make some plans for the future and it’s time to be happy.
    I’ve learn this submit and if I could I wish to counsel
    you some attention-grabbing things or suggestions. Perhaps
    you could write next articles referring to this article.

    I desire to learn more things about it!

    Reply
  9. buy tiktok real followers

    I’m not sure where you are getting your information, but good topic.
    I needs to spend some time learning much more or understanding more.

    Thanks for fantastic information I was looking for this information for my mission.

    Reply
  10. do you know there are different hitboxes in rocket league

    Hello there, I discovered your site by the use of Google whilst searching for a comparable subject, your
    website got here up, it appears good. I have bookmarked it in my google bookmarks.

    Hello there, simply changed into alert to your blog via Google,
    and found that it’s really informative. I’m gonna watch out
    for brussels. I will be grateful in the event
    you continue this in future. A lot of folks
    shall be benefited out of your writing. Cheers!

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

Share this Doc
Jump to Topics

Powered By SOLVED EXCEL

SOLVED EXCEL
Scroll to Top