Here is a speedometer in Excel 2003. It’s an old file and the charting wasn’t done in the most economic fashion.
I used too many series while I could have consolidated a lot of the dial curves. It is still a good example of animation and displaying custom numbers on a chart.
There are two VBA macros involved, one for changing the speed value and the other for randomly changing the parameters of the display.