Gauge Chart- how to create reverse gauge chart

[Anonymous]

                                     

The first image is showing +ve profit in green so it can be easily done in gauge chart. But the second one is showing -ve profit in red and pointing in reverse direction, which i am unable to do it. we knw what profit means(selling price-cost price).

How to achieve the second gauge chart?

[ramasaisaksoft]

if we multiply the value with - we will get that right?

like

= -*sum(profit-cost)

correct me if i mistake my assumption