Jan 21, 2023 9:00 AM

Excel Speedometer Charts - How to build them and why YOU SHOULDN'T!

External YouTube Channel

How to build Excel Speedometer Charts or Gauge Charts, why they are BAD and what to use instead.

Excel Speedometer Charts - How to build them and why YOU SHOULDN'T!

How to build Excel Speedometer Charts or Gauge Charts, why they are BAD and what to use instead.

Download the example file

https://www.myonlinetraininghub.com/excel-speedometer-charts

In this Video

  • 0:00 Introduction
  • 0:18 Building Excel Speedometer Charts
  • 5:48 Dynamic Chart Label
  • 6:33 The Problem with Speedometer Charts
  • 7:16 Alternatives to Speedometer Charts

What is a Excel Speedometer Charts?

Excel Speedometer Charts, also known as ‘Gauge Charts’ are often used to illustrate progress on a particular goal. They usually consist of a single needle that points to the current performance level based on the data provided by users. While they may look attractive and be easy to create, it is important to remember that these charts lack any context or meaning beyond simply showing where the needle currently stands - making them difficult for viewers to quickly interpret and understand. Furthermore, depending on how much information you try to display in one chart, the complexity of your visualization can quickly become overwhelming. As such, it is generally recommended that you avoid using Excel Speedometer Charts and instead opt for more meaningful visualizations like bar graphs or line charts which provide more context and clarity in their design.


First, go to the Excel ribbon, click on Insert, go to the chart section and, under the dropdown seen in the screenshot below click on the doughnut chart. Right- ...

  • [How to Create a SPEEDOMETER Chart [Gauge] in Excel]

https://excelchamps.com/blog/speedometer/

In “Format Data Point”, go to “Series Options” and add 5% in “Point Exploration”. At his point, you have a ready-to-use SPEEDOMETER (like below), just a final ...

How To Build Gorgeous Speedometer Charts and Why You Shouldn't Use Them - I Will Teach You Excel. The argument for and against using Speedometer Charts I'll ...