Gauge Chart Issue

[vanderson009]

Hi guys,

I have to create Actual Vs Budget by using Gauge Chart.

Can anybody tell me how to create this by using gauge chart.

-- Thanks and Regards,

Villyee

[Peter_Cammaert]

Create a Gauge chart (e.g. a Dial) without dimensions and with a single expression like:

= sum(Actual) / sum(Budget)

or

=(sum(Actual) - sum(Budget)) / sum(Budget)

Set the number format to percentage, and the scale from 0 to 1 (or higher if you use the first expression.

Then go and experiment with the various settings.

Peter