Gauge Chart : [Dial Chart]

Hello world

Wanna make an Amazing Gauge Chart ?

Its Formally Known as Dial Chart,you can follow some simple steps to create.

  I have used some VBA Code to make the needle animated :

Here is the Code to Move Needle

Sub MoveNiddle()

    DoEvents

    If Range("rngNiddlePos").Value = Range("Sales").Value Then Exit Sub

    Range("rngNiddlePos").Value = Range("rngNiddlePos").Value + 1

    MoveNiddle  ' Recursive Function

End Sub

Sub Move()

    Range("rngNiddlePos").Value = 0

    MoveNiddle

End Sub  

Download Link for animated dial chart is :

http://www.2shared.com/file/VjAbZvKC/DialChart1.html



Download link for Steps - How to Create Dial Chart :
http://www.2shared.com/file/eOFOlhUY/DialChartSteps.html



Hope you will like it