Creating a Speedometer in Excel, Part #2 – tutorial

02/11/2011

The previous tutorial (first half) explained how to download a speedometer picture from www.flickr.com 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…

Read More >>

Creating a Speedometer in Excel, Part #1 – tutorial

02/10/2011

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 www.flickr.com. 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…

Read More >>

A Family of Speedometers in Excel

02/09/2011

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]

Read More >>