Custom Charts in Excel :: Gauge Chart (aka Dial/Speedometer Chart)

Posted: August 7, 2013 by MaxFraudy in Excel
Tags: , ,

Although this is not my personal favorite chart, I have seen that many people find it fabulous since it looks good on a dashboard. I think that it takes too much space for the small information that it conveys. But then, that’s just me.

Gauge Chart

Gauge Chart

Now let’s see how to build the Gauge Chart.

Step 1: Set up your data such that you have four points – one each for the three RAG zones and one that is your scale. e.g. if I’m plotting values 0-100, my fourth point would have value 100.

Gauge Chart - Data

Gauge Chart – Data

Step 2: Now plot a doughnut chart using data on the left. You will end up with a chart looking like this.

Doughnut Chart

Doughnut Chart

Step 3: To make this chart look closer to what we want, do this:

  • Right Click on the plot -> Format Data Series -> Series Options -> Angle of First Slice -> Change it to 270 degrees
  • Change the fill color of the data points to Red, Amber & Green.
  • The last point is not to be shown. Make it ‘No Fill’.

Step 4: Now that you have the gauge, you need to put a needle onto it. To do that, use the data on the right and add another series on the same chart. Now your chart will look like this:

Double Doughnut

Double Doughnut

On this chart, you need to:

  • Change the Series 2 chart type to Pie chart
  • Rotate it to 270 degrees (just like you did for the doughnut chart)
  • Make all points except the needle invisible by making them ‘No Fill

Now you should be able to see what you were looking for. You can also download the template for Gauge Chart.

Previously in Custom Charts:

  1. Thomas Ellebæk says:

    Very nice!

  2. Chalie Hayes says:

    Can you add a second needle to this? I need the first needle to represent the current month, and the second needle (perhaps a different color?) to represent year-to-date. Appreciate any help.

Share your thoughts/feedback

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s