Interactive dashboards in Google sheets
Автокөліктер мен көлік құралдары
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
Пікірлер: 38
This is some of the best and most useful content I've found on Google Sheets. Thanks!
@learnspreadsheets
4 ай бұрын
Wow! That’s so kind 😃 glad you like it! Happy to make more sheet content 🤣
Thanks David, LOVE IT! This is very helpful. Enjoy your vidoes.
@learnspreadsheets
3 ай бұрын
Thanks so much! That’s awesome 😃
This is really good!
@learnspreadsheets
5 ай бұрын
Glad you find it useful 😃
Literally the most helpful video!! Thank you!
@learnspreadsheets
Ай бұрын
Glad you like it!
Great video! I have definitely found most of the charts I wanted to use all in one video. Thanks for this.
@learnspreadsheets
2 күн бұрын
Nice one!
Awesome Man!!!!!!
@learnspreadsheets
5 ай бұрын
Haha what a great emoji! Glad you like that video 😃
Very usefull information, thank you for this video!
@learnspreadsheets
2 күн бұрын
Ya thanks!
Thanks! Just what I was looking for. 😊
@learnspreadsheets
2 күн бұрын
Thanks for saying that - very kind!
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!!
@learnspreadsheets
2 ай бұрын
Aww wow thanks for the kind words, glad it helped and the slicers work now!
THANKS
@learnspreadsheets
5 ай бұрын
Glad you like it!
thanks
@learnspreadsheets
6 ай бұрын
No worries!
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
@learnspreadsheets
4 ай бұрын
That can be annoying & I’m not sure how to fix sorry, excel does that too
Thanks For teaching sir... How you are showing this whole project in full screen even in 150%zoom 🤯 🤷♂️. GIVE TRICKS SIR
@learnspreadsheets
4 ай бұрын
Hahaha! F11 makes a browser fill screen & windows key + will zoom in!
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?
@learnspreadsheets
2 ай бұрын
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
@otappiah
2 ай бұрын
@@learnspreadsheets I can access it now. Thanks
thank you for this video . I could not download the data to practice .
@learnspreadsheets
2 ай бұрын
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
@learnspreadsheets
4 ай бұрын
Yup
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".
@learnspreadsheets
7 ай бұрын
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
@learnspreadsheets
4 ай бұрын
Freeze panes shouldn’t affect chart ranges so I’m not sure what you mean sorry