Radial bar chart

[Villalobos]

Hello,

I would like to reproduce a radial bar chart but i can not figure out, could you please help me to do this?

 

[Hui]

Do you mean like this:


Change values
Then right click on a series and set start position to 270
or see attached:

 

[Villalobos]

Thank you Hui the help.
Could you give me one more advice... how to add the "black bar" to the chart with "start and end line" and major tick marks (cross)? Is it possible?

 

[Hui]

How's about this bad boy?


Yes done in Excel

See attached file:

The Labels may not display properly in Excel < 2013

 

[Villalobos]

Wow... this is brilliant Hui!
Thank you the help and that you shared your awesome knowledge!

 

[Myles Echenique]

How's about this bad boy?
View attachment 24286

Yes done in Excel

See attached file:

The Labels may not display properly in Excel < 2013

Hey there,

First of all, awesome stuff! Did not know that this was possible natively in Excel

Trying to recreate this in Excel and I was wondering if negatives could be shown in this or not?

Additionally, what purpose do the values on the column on the right serve?

 

[Hui]

Yes, You can use nagatives
The values are purely labels

 

[Seahorse]

Clever stuff, so A9 to F18 are the Dimensions and the cordinates for the black bars. Col G are the labels for chart. D6 & 7, E6 & 7 generate the green and red bars, with E being a transparent bar in a second series, is that actually required? If you use it for percentages, it looks to go from 0.01 to 7 if you actually want to go from 1 - 100, which is awkward.