How to create a Dashboard in Google Sheets (Step-by-Step Guide)

Champion Challander Tech December 28, 2024
Video Thumbnail

About

No channel description available.

Video Description

Work with me: https://www.championchallander.com Book Tracker Template: https://sheetgeekhq.gumroad.com/l/booktracker Shop more templates: https://sheetgeekhq.gumroad.com/?utm_source=youtube How to make a Dashboard in Google Sheets. This dashboard has a table with graphs. This is a good dashboard and is the exact template that has helped me stay on track with my reading this year! Follow my socials! SheetGeek TikTok: https://www.tiktok.com/@sheetgeek SheetGeek Instagram: https://www.instagram.com/sheetgeekhq Instagram: https://www.instagram.com/championchallander 0:00 Intro 0:32 Spreadsheet Overview 2:32 Starting from a blank sheet 2:57 Making the table 4:19 Adding the status bar formula 6:04 Adding dropdown lists 16:10 Making the dashboard 16:53 Adding a pie chart 19:13 Adding scorecards 22:16 Adding a line chart 27:03 Adding an area chart 34:17 Adding slicers

You May Also Like

Boost Productivity with These Google Sheets Tools

AI-recommended products based on this video

Loading...
(2 Pack) Outlet Wall Mount Holder for Google Home Mini and Google Nest Mini, A Space-Saving Accessories with Cord Management for Google Mini Smart Speaker, No Messy Wires or Screws

(2 Pack) Outlet Wall Mount Holder for Google Home Mini and Google Nest Mini, A Space-Saving Accessories with Cord Management for Google Mini Smart Speaker, No Messy Wires or Screws

(3,057)
$15.99
Prime
200+ bought in past month
Loading...
INIU 45W Power Bank, Ultra Small 10000mAh Portable Charger, USB C in&Out Fast Charging Battery Pack, Travel External Phone Powerbank Compatible with iPhone 16 15 Samsung S25 S24 Google Pixel iPad etc

INIU 45W Power Bank, Ultra Small 10000mAh Portable Charger, USB C in&Out Fast Charging Battery Pack, Travel External Phone Powerbank Compatible with iPhone 16 15 Samsung S25 S24 Google Pixel iPad etc

(520)
$41.42
PrimeFREE delivery Sat, Jun 14
500+ bought in past month
Loading...
INIU Power Bank, USB C in&Out Slimmest 10000mAh Portable Charger, Triple 3A High-Speed Charge External Battery Pack, Flashlight Phone Charger for iPhone 16 15 14 13 12 Samsung S22 S21 Google LG iPad

INIU Power Bank, USB C in&Out Slimmest 10000mAh Portable Charger, Triple 3A High-Speed Charge External Battery Pack, Flashlight Phone Charger for iPhone 16 15 14 13 12 Samsung S22 S21 Google LG iPad

(79,368)
$25.99
FREE delivery Wed, Aug 20 on your first order
5K+ bought in past month
Loading...
INIU 45W Power Bank, Ultra Small 10000mAh Portable Charger, USB C in&Out Fast Charging Battery Pack, Travel External Phone Powerbank Compatible with iPhone 16 15 Samsung S25 S24 Google Pixel iPad etc

INIU 45W Power Bank, Ultra Small 10000mAh Portable Charger, USB C in&Out Fast Charging Battery Pack, Travel External Phone Powerbank Compatible with iPhone 16 15 Samsung S25 S24 Google Pixel iPad etc

(520)
$41.42
PrimeFREE delivery Sat, Jun 14
500+ bought in past month
Loading...
INIU Power Bank, USB C in&Out Slimmest 10000mAh Portable Charger, Triple 3A High-Speed Charge External Battery Pack, Flashlight Phone Charger for iPhone 16 15 14 13 12 Samsung S22 S21 Google LG iPad

INIU Power Bank, USB C in&Out Slimmest 10000mAh Portable Charger, Triple 3A High-Speed Charge External Battery Pack, Flashlight Phone Charger for iPhone 16 15 14 13 12 Samsung S22 S21 Google LG iPad

(79,368)
$25.99
FREE delivery Wed, Aug 20 on your first order
5K+ bought in past month
Loading...
Magnetic Car Mount Air Vent Cell Phone Holder, Universal Vehicle Dash Dashboard Ac Airvent Cellphone Magic Stand with Clip Hook, for iPhone 16 15 Samsung Lenovo Google etc

Magnetic Car Mount Air Vent Cell Phone Holder, Universal Vehicle Dash Dashboard Ac Airvent Cellphone Magic Stand with Clip Hook, for iPhone 16 15 Samsung Lenovo Google etc

(128)
$21.99
FREE delivery Tue, Jun 17 on your first order
Loading...
(2 Pack) Outlet Wall Mount Holder for Google Home Mini and Google Nest Mini, A Space-Saving Accessories with Cord Management for Google Mini Smart Speaker, No Messy Wires or Screws

(2 Pack) Outlet Wall Mount Holder for Google Home Mini and Google Nest Mini, A Space-Saving Accessories with Cord Management for Google Mini Smart Speaker, No Messy Wires or Screws

(3,057)
$15.99
Prime
200+ bought in past month
Loading...
INIU 45W Power Bank, Ultra Small 10000mAh Portable Charger, USB C in&Out Fast Charging Battery Pack, Travel External Phone Powerbank Compatible with iPhone 16 15 Samsung S25 S24 Google Pixel iPad etc

INIU 45W Power Bank, Ultra Small 10000mAh Portable Charger, USB C in&Out Fast Charging Battery Pack, Travel External Phone Powerbank Compatible with iPhone 16 15 Samsung S25 S24 Google Pixel iPad etc

(520)
$41.42
PrimeFREE delivery Sat, Jun 14
500+ bought in past month
Loading...
INIU Power Bank, USB C in&Out Slimmest 10000mAh Portable Charger, Triple 3A High-Speed Charge External Battery Pack, Flashlight Phone Charger for iPhone 16 15 14 13 12 Samsung S22 S21 Google LG iPad

INIU Power Bank, USB C in&Out Slimmest 10000mAh Portable Charger, Triple 3A High-Speed Charge External Battery Pack, Flashlight Phone Charger for iPhone 16 15 14 13 12 Samsung S22 S21 Google LG iPad

(79,368)
$25.99
FREE delivery Wed, Aug 20 on your first order
5K+ bought in past month