Pie Chart

[Graysleaf]

Hello,
I would like to make a pie chart that contains a scale of 0 to 5. 0 begins in the middle of the circle and the outer circumference is 5. There would be roughly 100 pie pieces (Comments) that will individually be rated 0 to 5 (Score). My inputs would be as follows

__A______B______C____ D
1 Category Average Score Comments
2 Labor___2.33_________(1 of 100)
3 Question_______3
4 Question 0
5 Question 2
6 Question 2
7 Documentation 3.00 (2 of 100)
8 Question_______2
9 Question 1
10 Question 4
11 Question 5
12 Question 3
etc.

Please let me know if you have any ideas how to build a pie chart for tracking the above inputs.

 

[Worf]

Hello

A radar chart will give you the radial scale:

 

[Graysleaf]

Thanks Worf,
Its a first using the radar chart, but I think it will work for what I'm trying to do. I'm having trouble with the labels pulling data from a cell and showing correctly on the chart. How do I pull a label from one cell and have another cell with a number be graphed on the chart. It doesn't look quite right. The Radar chart is on a scale of 0 in middle to 5 on periphery. Any tips on how to manage the chart?

 

[Graysleaf]

Figured it out. Thanks