Circular Gauge Chart with Equal Segments

[#1]

HI,

I need to create a circular gauge chart split into 6 equal segments.  I then need to colour each of these segments Red, Green or White depending on the following calculation

Segment1  :

=if(sum(Segment1)/(sum(total_assessments)*2)=1,rgb(0,255,0),

if(sum(Segment1)/(sum(total_assessments)*2)>1,rgb(255,000,0),

if(sum(Segment1)/(sum(total_assessments)*2)<1,white())))

Segment2 :

=if(sum(Segment2 )/(sum(total_assessments)*2)=1,rgb(0,255,0),

if(sum(Segment2 )/(sum(total_assessments)*2)>1,rgb(255,000,0),

if(sum(Segment2)/(sum(total_assessments)*2)<1,white())))

... and so on for all six segments.

is this possible ??

many thanks!

[sunny_talwar]

Do you have a sample of where you stand right now? May be we can play around with what you have to get you to what you want