How to create Excel Gauge Chart | Speedometer Chart

DataCense
DataCense
3.3 هزار بار بازدید - 3 سال پیش - In this tutorial, we will
In this tutorial, we will learn how to create Gauge Chart or Speedometer chart in Excel.

Excel Speedometer or Gauge graph is one of the most popular chart types that attract managers. It’s easy to understand. It visualizes achievement or growth rate creatively.

A beautiful, and easy to understand chart always make your excel dashboard stand out.

Here is the step by step index for the video.

00:00 Intro
00:21 Data Behind the Chart
01:19 Create a Donut Chart
01:32 Angle of 1st Slicer as 270 degree
02:07 Format Donut Chart colors
02:45 Add Pointer/ Needle Data
03:07 Change Outer Donut to Pie, Secondary Axis
03:42 Align & Format Pie Chart
04:14 Format Pointer & Add Data Label
04:51 Link Data Label to Measured Value
05:09 Add Interactivity

You can download the file used in the video from below link
https://bit.ly/3tY4fzd

Also, check these videos if you want to learn more

1 Min Excel: If you enjoy short videos check this section
Shorts : Random

Excel: Check this playlist for Excel-related things
Excel

Keyboard Shortcuts: Check this section to save some time in everyday excel work
Excel Keyboard Shortcuts

Pivot Tables: Check this playlist for Pivot Table, Slicers, and Auto refreshing reports
Pivot Tables

Power Query: Check the Power Query playlist for Data Preparation & its Automation
Power Query

Power BI: Check the PowerBI related videos for Business Intelligence, Dashboard & Visualisations
Power BI



Please subscribe to our channel and  Follow us on other social media platforms for regular updates :

Tiktok https://vm.tiktok.com/ZSH28XEt/
Facebook Facebook: datacense
Twitter Twitter: datacense
LinkedIn LinkedIn: datacense
Instagram Instagram: datacense32
3 سال پیش در تاریخ 1399/11/25 منتشر شده است.
3,392 بـار بازدید شده
... بیشتر