Polar pie chart diagram

[knigt]

Hi,

I want to make an Polar pie chart in excel. And I want to make it look like the image below. But I can not find and a good explanation for it. Can anyboy help me?

I need a diagram with 8 slises. All the slises need to have de same angle.

THNX

Knipsel.JPG

[arlu1201]

Hello knigt,

Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.

[Ochimus]

Knigt,

What you are looking for is a "Circumflex" chart. Basically you create a Donut chart with the number of segments set by however many measures you want (in your case eight rows), and columns of as many "rings" as you want (usually 10, so each "slice" is 10%). Each "Ring" has two sets of measures, one representing "filled" and the other "blank". If the score is more than the minimum value for the slice, the formula puts "10" in the filled column. If the value is less than the minimum value of the segment, the "filled" column becomes Zero and the "blank" column becomes "10" So if your score for Q1 is 80%, rows 1 - 8 on the table will have "10" in the filled column and rows 9 - 10 will have "10" in the "blanks". You then set each "filled" sections in the graph to whatever colour you want, leaving the "blank" slices unfilled, which is how you get the mixture at the end.

Try this excellent instruction on YouTube: https://www.youtube.com/watch?v=9U1RzHzCDWE

Ochimus