Create a Gauge or Speedometer Chart - Google Sheets

Gauge charts aka Speedometer charts are one of those fancy looking charts that try to represent a metric with the car dashboard analogy. This dashboard analogy is good in small doses because it's preferable to have something similar to a basic car dashboard as opposed to airplane cockpit dashboard. Thankfully creating a gauge chart in Google Sheets is fairly straight forward and easy to do. So buckle up and check out the video.
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltrain...
📚 Excel Books & Tech Gear ➜ www.amazon.com...
⚙️ Tools: Screencasting ➜ techsmith.z6rj...
⚙️ Tools: Microsoft Office ➜ microsoft.msaf...
⚙️ Tools: TubeBuddy ➜ www.tubebuddy....
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to / doughexcel
#googlesheets
#excel
#msexcel
#doughexcel

[@irfansensoy5901]

Hello. How can we ensure that this indicator is updated according to the latest data in a file where data is recorded at regular intervals on the sheet?

[@tsekokhumalo3042]

Super star

[@DougHExcel]

Thanks!!

[@iitsGreedz]

Mine does not give the costomise option it keeps on saying add data

[@kamiljelinek2048]

Thank you a lot for this wideo. It was very helpful for me and acctually what I really need. In so short wideo! Thank you a lot again! ;)

[@DougHExcel]

You're very welcome!

[@zamapon]

Bravo! bro, you're very kind

[@DougHExcel]

Thank you kindly!

[@timelesstimesgoneby]

How to set gauges to all line up without being stacked sheets

[@ЕфтимАлександров]

Can we have more than three colours on the gauge?

[@faengelm]

Very well explained.

[@mrnoname7229]

Is it possible to create a functioning gauge chart in Word? I’m going crazy trying to even find out.

[@DougHExcel]

Create in excel and link from word may work. Create a Speedometer Chart in Excel 2010
th-cam.com/video/M7RZjVV0MRU/w-d-xo.html

[@jennawright2734]

Okay but is it possible to combine multiple gauges into one gauge? Where all of the data points would add up to 100% completion? For example, tracking parent teacher conferences. I have a list and want to figure out how close to 100% completion, I am. How would I do that?

[@DougHExcel]

sounds like 100% is the target, so maybe theses other target type charts could help th-cam.com/video/aY8ctL2g1GM/w-d-xo.html

[@malikastar9265]

That's interesting, thank you a lot !

[@DougHExcel]

You are welcome!

[@AnthonyCamiloG]

Thanks!!!!

[@DougHExcel]

You’re welcome!