Interactive dashboards in Google sheets
ฝัง
- เผยแพร่เมื่อ 18 พ.ค. 2024
- Google Sheets allows you to create charts and choose to aggregate easily, and if you add Slicers then it can become interactive. Card visuals and Table visuals are interesting to explore as Excel doesn't have them, plus using Pivot Tables allows you to sort the charts or have crosstab analysis which can be made more visual through sparklines and conditional formatting. I cover all this in my video.
Other links:
You can download the example files here: www.xlconsulting-asia.com/you...
Sparklines in Google Sheets: • Sparklines: In cells c...
Pivot Tables in Google Sheets: • Google sheets Pivot ta...
Interactive dashboards in Excel: • Interactive dashboards...
00:00 Introduction
00:37 Create an aggregated chart
02:30 Card visuals
03:18 Pivot Tables and sorted charts
04:22 Chart only dashboard
06:09 Slicer for interactivity
11:03 Pivot table date groups
12:21 Paginated table chart
13:20 Conditional format and sparklines
14:34 Colour picker to match logo etc
16:04 Final dashboard touches
16:38 Marker 11 - ยานยนต์และพาหนะ
This is some of the best and most useful content I've found on Google Sheets. Thanks!
Wow! That’s so kind 😃 glad you like it! Happy to make more sheet content 🤣
I'm pretty new with sheets but was tasked to make a dashboard, and man, I was banging my head against the wall because I could NOT figure out why my slicers weren't affecting the chart, THANK YOU!!
Aww wow thanks for the kind words, glad it helped and the slicers work now!
Thanks David, LOVE IT! This is very helpful. Enjoy your vidoes.
Thanks so much! That’s awesome 😃
This is really good!
Glad you find it useful 😃
Awesome Man!!!!!!
Haha what a great emoji! Glad you like that video 😃
THANKS
Glad you like it!
thanks
No worries!
Thanks For teaching sir... How you are showing this whole project in full screen even in 150%zoom 🤯 🤷♂️. GIVE TRICKS SIR
Hahaha! F11 makes a browser fill screen & windows key + will zoom in!
Hi, how to keep the charts in position when using slicer? Whenever I use slicer the charts I made keeps on being a mess again
That can be annoying & I’m not sure how to fix sorry, excel does that too
thank you for this video . I could not download the data to practice .
Hi, sorry there was an error with the file download. You can get it from this link, let me know if there are any issues: xlconsultingasia.sharepoint.com/:x:/s/Blogging/EerDGBHZRz9FrNWcenMOwEgBv2sn449-3pn_56O3CkAriQ?e=RTXEa2
yh
Yup
Hi. This video is really easy to understand.
The link doesn't seem to work for me, is there another way I get access to the files?
Hi, thanks for pointing it out, there was an error with the file download site. You can get it from this link, let me know if there are any issues: xlconsultingasia.sharepoint.com/:x:/s/Blogging/EerDGBHZRz9FrNWcenMOwEgBv2sn449-3pn_56O3CkAriQ?e=RTXEa2
@@learnspreadsheets I can access it now. Thanks
You make the example file available for download, but the difficult part is knowing what it is among a bunch of files stored on YT public files.
There is no file named "Interactive dashboards".
Hi sorry about that, it should be there now in the part for Google files: www.xlconsulting-asia.com/youtube-files.html
How to show charts when freez a row .it disapear
Freeze panes shouldn’t affect chart ranges so I’m not sure what you mean sorry