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…


Creating a Speedometer in Excel, Part #1 – tutorial


This is the first half of a tutorial which shows how to create a speedometer in Excel. The model is essentially a 2D scatter chart having as background the picture of a speedometer dial downloaded from Before using the photograph you need to erase the arm of the speedometer from the picture using Photoshop or other photo editing software. In the model I replaced the deleted arm with a moving arm created from…


A Family of Speedometers in Excel


Hi guys, by popular demand, this is a file containing five different animated speedometers and a tachometer (rpm-meter). I can recognize two models: a Toyota Camry and a Ford Crown Victoria. They work great. The rest I am not sure what they are, I would appreciate if you tell me. Just leave a comment. The model works in all versions of Excel. Cheers, George [sociallocker][/sociallocker]