How to create Excel Gauge Chart | Speedometer Chart
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
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
بـار بازدید شده