Gauge chart creation

[#1]

Hi

Can some one help me in creating the gauge chart

any of the below charts would be helpful

[robert_mika · Accepted solution]

Expression tab: One expression=1

Presentation tab  Segment 1 =0

                         Segment 2 = =sum(sales)/sum({1} sales)

                         Text in Chart: =num(sum(sales)/sum({1} sales),'00.0%')

[#3]

Hi Robert

When i was trying to convert the same gauge chart to test tube chart

I'm unable to see the change in colour in test tube chart can you pleas ehelp me out

[robert_mika]

Here are examples you can fallow.

Thermometer Gauge Chart with 3 colors