I suggest you read this,
http://peltiertech.com/Excel/Charts/SpeedometerXP.html

some examples,

http://www.businessobjects.com/produ...sius/demos.asp
http://www.dashboardinsight.com/cata...ds-scorecards/