Creating a Speedometer in Excel, Part #2 – tutorial

The previous tutorial (first half) explained how to download a speedometer picture from and how to alter it (delete the needle) using a freeware called Gimp (similar to Photoshop).
– The model replaces the deleted needle from the picture with a moving one created from a chart line.
– This second half of the tutorial explains the geometry, trigonometry and VBA code used to build a new rotating speedometer needle to replace the static one deleted using Gimp.

[sociallocker] [/sociallocker]

This article has 6 Comments

  1. was waiting since i saw the cockpit reporting in ajax….

    i love the thing…..

    waiting to implement at my work….

    Really thanx a tonnn……

  2. Thanks Abdul,
    As you mentioned the formula below is the parametric circle formula. Strictly speaking the excel formula that you wrote on above has a=0, b=0 (you can modify that if you wish) but there are two different scale factors you can choose (B22, C22) and they are adjusted function of the size of the clock face you paste in. Normally B22 should be equal to C22 and equal to the clock arm length, but if you choose a clock which is non-square (rectangular for instance) you could have the clock arm ends move on ellipses rather than circles.

  3. best of excel sheets which i have seen,

    couldn’t have imagine this

    thank you for Sharing

  4. B22*SIN(RADIANS(E$9))+C22*COS(RADIANS(E$9))

    what is the relation of this formula to equation of circle , X=a+cost, Y = b+sint

    Please explain

  5. Thanks Kamal! I agree with you on this one. I either remember the easy ones or I go to Wikipedia for some help. My parents were both high school teachers so I was sometimes forced to spend more time with formulae than with my hobbies. Of course the copy-paste strategy is the best when is not too laborious.

  6. George I am jealous , being human to remember all those trigonometrical formulae and macros.. 😛 copy paste is always best strategy , untill it has got copy rights.
    Speedo meter is Super. 🙂

Leave a Reply

Your email address will not be published. Required fields are marked *