Interactive dashboards in Google sheets

[@gabrielvasquez6477]

This is some of the best and most useful content I've found on Google Sheets. Thanks!

[@learnspreadsheets]

Wow! That’s so kind 😃 glad you like it! Happy to make more sheet content 🤣

[@joshr1358]

Thanks for this! I work predominantly with Google Workspace and this video has really helped me, I'm able to apply the logic you've displayed here to some of the things that I'm currently working on

[@nerlyherrera4433]

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]

Aww wow thanks for the kind words, glad it helped and the slicers work now!

[@sovecheasophanna]

Thanks David, LOVE IT! This is very helpful. Enjoy your vidoes.

[@learnspreadsheets]

Thanks so much! That’s awesome 😃

[@IbrahimBashir]

Great video! I have definitely found most of the charts I wanted to use all in one video. Thanks for this.

[@learnspreadsheets]

Nice one!

[@itskristieali]

Literally the most helpful video!! Thank you!

[@learnspreadsheets]

Glad you like it!

[@sivaasflame]

I have made an dashboard recently in goodle sheets . When i download as xlsx file (for github upload ) and open it using excel , it completely collapsed all the alignment. What should i do??

[@learnspreadsheets]

Sorry to hear. Google makes things compatible when importing from excel more than vice versa sadly, there are so many components of what could be in a dashboard that it’s impossible to solve the issue for you without knowing first, it’ll have to be looked at step by step, best to ask in a forum where you can upload photos & files & see if someone can help there

[@jasonmotley]

I'm trying to test if the Dashboard works when "Published to the Web" ... Does it? Doesn't seem to work for me.

[@mycafalcunaya876]

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]

That can be annoying & I’m not sure how to fix sorry, excel does that too

[@mitooquerer]

Thanks! Just what I was looking for. 😊

[@learnspreadsheets]

Thanks for saying that - very kind!

[@analystintelligence]

This is really good!

[@learnspreadsheets]

Glad you find it useful 😃

[@Awahab44]

Thanks For teaching sir... How you are showing this whole project in full screen even in 150%zoom 🤯 🤷‍♂️. GIVE TRICKS SIR

[@learnspreadsheets]

Hahaha! F11 makes a browser fill screen & windows key + will zoom in!

[@Tigrenocchek]

Very usefull information, thank you for this video!

[@learnspreadsheets]

Ya thanks!

[@mfourmanagement9440]

Awesome Man!!!!!!

[@learnspreadsheets]

Haha what a great emoji! Glad you like that video 😃

[@PhuongPham-ox6se]

Useful, thank you very much ^^

[@learnspreadsheets]

Glad you like it!

[@otappiah]

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]

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]

@@learnspreadsheets I can access it now. Thanks

[@ManishSaini-l3r]

THANKS

[@learnspreadsheets]

Glad you like it!

[@safamoh1558]

thank you for this video . I could not download the data to practice .

[@learnspreadsheets]

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

[@catedoge3206]

yh

[@learnspreadsheets]

Yup

[@JoseAntonioMorato]

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]

Hi sorry about that, it should be there now in the part for Google files: www.xlconsulting-asia.com/youtube-files.html

[@FateOfTheElephant]

voice like a Head Space instructor

[@learnspreadsheets]

Hahaha thanks! I think! I like that guy he’s pretty calming 🙃

[@FateOfTheElephant]

@@learnspreadsheets exactly, very calming. Thank you for sharing your knowledge

[@masadi1980]

thanks

[@learnspreadsheets]

No worries!

[@solooutvlog]

How to show charts when freez a row .it disapear

[@learnspreadsheets]

Freeze panes shouldn’t affect chart ranges so I’m not sure what you mean sorry