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 chart line.  The tutorial will not show you how to use Photoshop but it will casually introduce you to a free Photoshop substitute called Gimp and demonstrate how to do the aforementioned image alterations.  The second half of the tutorial (in the next post) will explain how to insert the dial photo in the chart and the formulas used to drive the speedometer arm.

This article has 6 Comments

  1. Kamal, unfortunately I don’t have Photoshop. Thanks for raising the issue. It helps me find out what my visitors really need. Maybe I should buy a copy and do some tutorials. Cheers, George

  2. If somebody knows photodhop, the model can be customized to their tastes. George, I want to know if you are providing Photoshop tutorials as well ?
    Great work man. 🙂

  3. Do you happen to have any work on Gauges or Theomometers. I am trying to develop one for sales dashboards and the numbers on the dials need to be changed dynamicly

  4. Great Tutorial. Thanks for the time and efforts

  5. Pingback: Creating a Speedometer « Excel Unusual | PhotoShopped

Leave a Reply

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