Hack together a Gauge Chart in Excel without sweat

Share

Facebook
Twitter
LinkedIn

excel-speedometer like gauge chart - how to

Gauges are a familiar metaphor, everyone can understand them, you can see them everywhere – near your stove, ac, car, gaming console, pc – you name it. So, when you are preparing a chart to tell a point, gauge chart like the one above can be effective. (I know charting pros like Jon Peltier wouldn’t agree with this and prefer speedometer charts only in cartoons.)

Unfortunately Excel doesn’t have a gauge chart as a default chart type. They of course have a 3d line chart, but let us save it for your last day at work. Meanwhile we can cook a little gauge chart in excel using a donut and pie (not the eating kind) in 4 steps.

Click here to download the excel speedometer chart template and play around.

1. Have your data ready

For a typical gauge or speedometer chart we need to have these 5 different valuesGauge - speedometer table excel values

  • What the is gauge size?
  • What is the range of Red zone?
  • What is the range of Yellow / Amber zone?
  • What is the range of Green zone?
  • What is the value to be shown on Gauge?

In our case we can use typical values like you see on the right.

2. Make a doughnut chart using Red, Yellow and Green Values & Pie Chart

Create doughnut and pie charts in excel to get a gauge chart

This is a simple step, just select the data for speedometer and click on insert chart and select “Doughnut” as chart type. Make sure you have added a data row in the end with value as 100 to get a gauge with 180° or 50 to get a gauge with 270°

Making the pie chart

This is another simple step, easier than eating pie. Just create a pie chart with 3 values,

  • Gauge value
  • 1
  • 200 minus gauge value + 1

3. Blank out the bottom half of doughnut and pie charts

Creating a speedometer chart in excel - how to? Just select the blank portions of doughnut and pie charts and set their border & background colors to none.

While you are at it, adjust the colors of donut portions to red, amber and green (or your favorite speedometer colors)

4. Finally, put the pie chart on top of donut chart

Final step - overlay pie chart on top of donut chart - excel spreadsheetJust drag and drop the pie chart on the donut chart. Tweak the colors if needed, adjust the “send to background” / “bring to foreground” settings.

That is all, you will now have a neat looking gauge / speedometer chart to show off. Don’t forget to download the Microsoft excel gauge chart template

Also try: Thermometer chart, Partition chart, Chart around the clock, Min-max charts

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Overall I learned a lot and I thought you did a great job of explaining how to do things. This will definitely elevate my reporting in the future.
Rebekah S
Reporting Analyst
Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

21 Responses to “Make a Pivot Table in Excel [15 Second Tutorial]”

  1. [...] First step is to create Pivot Table. Here is a video tutorial on making pivot tables. [...]

  2. Wilson says:

    Dear Sir,

    I would like to study pivot table from basics detailed.Pls send me the tips of that

  3. baran says:

    merccccccccccccccccccccccccccccccccccccc

  4. [...] Click here to see a video tutorial of making pivot tables in excel | One more Pivot Table Video Tutorial [...]

  5. surbamanyam says:

    it is very useful

  6. jitender says:

    hello sir

    please send me some information of pivotable. and how to use it
    because I am beginer so how can i learn it the pivotable.
    and sir will you send me pivotable data because i have no data and i don't
    know how to applyed for the pivotable. give some videos so I learn quikely.

    thank you
    and my best
    anticipation

  7. keri says:

    Hi,

    This tutorail was helpful. If possible can you please email me some data, so I can create another pivot table? I am trying to learn ASAP and need some info.

    Thank you

  8. yemi says:

    Top of the day to you. can you pls send me a detailed tutorial on the pivot table tutorial? Thanks.

  9. karthick says:

    Hi,
    please tell me how to use Pivot table.

  10. Pooja says:

    Dear Sir,
    I visited this website of urs for the very first time and trust me this is fabulous.i learnt pivot table through this.Thanks a lot.In corporate world nobody gonna make u learn these things.m very grateful to u.This is a great initiative from ur side.Commendable job done.Hats off to u.For beginners also this is very helpful.The way this website makes u learn excel is very good.

    Pooja

  11. Priscilla says:

    Can you please email me information to put into a pivot table and possibly a complete set of instructions?  I am a beginner to pivot tables and am possibly interested in obtaining a position that requires pivot tables.  thank you.

  12. [...] Click here to see a video tutorial of making pivot tables in excel | One more Pivot Table Video Tutorial [...]

  13. Kawsar says:

    It's simply great..!!

  14. James Perry says:

    Cool!
    Fast but not furious.

  15. Adepoju Teniola says:

    Pls email me details of pivot table. I want to learn it asap because I just got a job that requires this. Thanks

  16. nihal ahmed says:

    it is very useful..............thanks

  17. Tabassum says:

    Sir please can u send me the complete explanation of pivot tables from basics

  18. Guruprasad says:

    hello,

    I wanted to know how to put pivot with emp id, emp name, emp position in one row.

    Ex:-
    cel A4 should have Emp id
    Cell B4 should have Emp Name
    Call C4 should have Emp Position

    many thanks in advance

  19. George Dorne says:

    Nice information, thanx my dear.

Leave a Reply