Speedometer in Excel - Create a Speedometer Chart Guide

A speedometer chart in Excel, also called a gauge chart, is a popular visualization tool for dashboards and reports. It mimics a real speedometer to display key performance indicators (KPIs) like completion percentage, budget utilization, or target achievement. This guide walks you through creating a professional speedometer chart in Excel without using any add-ins or VBA code.

What Is a Speedometer Chart in Excel?

A speedometer chart uses a combination of a doughnut chart and a pie chart to create the illusion of a gauge. The chart shows a value on a scale from minimum to maximum, with colored bands representing performance levels such as poor, average, and excellent. The needle points to the current value on the gauge. This type of visualization is widely used in business dashboards because it provides an instant, intuitive understanding of performance metrics.

Step 1: Prepare Your Data

To build a speedometer chart, you need to set up three data tables in Excel. First, create the data for the gauge segments. You need three sections: low (red), medium (yellow), and high (green). For example, for a 0-100 scale, set values like 40 for low, 30 for medium, and 30 for high. Second, create the pointer data: the pointer value itself, plus a dummy value to calculate the angle. Third, create the label data to display the current value.

A well-structured data table is the foundation of a clean speedometer chart. Organize your data in a separate area of the worksheet to keep the dashboard area clean.

Step 2: Create the Gauge Base

Start by creating a doughnut chart using your segment data. Select the three segment values and insert a doughnut chart from the Insert menu. The chart will show a ring divided into three parts. Double-click the chart to open the formatting options. Rotate the doughnut by setting the angle of the first slice to 270 degrees. This positions the start of the gauge at the bottom left. Adjust the doughnut hole size to around 50 percent to create the proper ring thickness. Format each segment with the appropriate colors: red for low, yellow or amber for medium, and green for high.

Step 3: Add the Speedometer Needle

The needle is created using a pie chart overlaid on the doughnut chart. Add a new series to the chart using your pointer data. Change the chart type of this new series to a pie chart. The pie chart needs three data points: the pointer value, a dummy value that represents the rest of the half-circle, and a tiny invisible wedge for the center. Format the pointer wedge with a bold color and remove the fill from the other wedges. The needle will now point to the correct position on the gauge.

Step 4: Format and Label the Gauge

Remove the legend and chart title if they are not needed. Add data labels to show the scale values at the appropriate positions. You can add text boxes or shape objects to mark the minimum, midpoint, and maximum values. For a clean look, remove the chart border and set the chart area fill to transparent so it blends with the dashboard background. Adjust the position and size of the chart to fit your dashboard layout.

Step 5: Make It Dynamic

The real power of a speedometer chart is when it updates automatically. Link the pointer value to a cell that contains a formula or a dashboard control. For example, you can connect it to a percentage completion formula, a drop-down selection, or a scroll bar form control. When the source value changes, the needle moves to the new position automatically. To create the most interactive experience, you can pair your Excel dashboard with a real-time data feed. For actual speed measurement needs, use our free GPS speedometer tool which provides instant speed readings without any setup.

Common Mistakes to Avoid

  • Wrong data arrangement: The segment data must be arranged in the correct order for the colors to appear in the right positions (low to high clockwise).
  • Incorrect rotation: The doughnut chart must be rotated exactly 270 degrees to start at the bottom. Any other rotation will misalign the needle.
  • Overcomplicating the design: A clean, simple gauge is more effective than one with too many colors or decorations. Stick to three or four segments maximum.
  • Not testing with real data: Always test your speedometer chart with different values to ensure the needle moves correctly across the full range.

Alternative: Using a Real Speedometer

While Excel speedometer charts are great for data visualization and reporting, they are not actual speed measurement tools. If you need to measure real speed while driving, cycling, or running, our online GPS speedometer provides accurate live speed readings using your device's GPS. It supports mph, km/h, knots, and m/s and works on any device with a browser and GPS.