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

[@learnspreadsheets]

Glad it helped! Yay

[@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!

[@thebesttechnical3608]

Thanks a lot for this simple yet powerful explanatory tutorial

[@learnspreadsheets]

Thanks so much for the comment! I'm glad you like it

[@sovecheasophanna]

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

[@learnspreadsheets]

Thanks so much! That’s awesome 😃

[@mrjuaco]

Thank you very much, I learned a lot with your lesson, very good video.

[@EhabGheidan]

Thank you so much for the efforts in doing this video, it is really amazing

[@learnspreadsheets]

Thanks!! Glad it’s useful for you

[@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!

[@AurélieNathalie-x9r]

Thank you for this video! it interested me a lot and helped me too

[@learnspreadsheets]

Im glad you liked it!

[@itskristieali]

Literally the most helpful video!! Thank you!

[@learnspreadsheets]

Glad you like it!

[@mfourmanagement9440]

Awesome Man!!!!!!

[@learnspreadsheets]

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

[@analystintelligence]

This is really good!

[@learnspreadsheets]

Glad you find it useful 😃

[@mitooquerer]

Thanks! Just what I was looking for. 😊

[@learnspreadsheets]

Thanks for saying that - very kind!

[@Tigrenocchek]

Very usefull information, thank you for this video!

[@learnspreadsheets]

Ya thanks!

[@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

[@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

[@PhuongPham-ox6se]

Useful, thank you very much ^^

[@learnspreadsheets]

Glad you like it!

[@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!

[@jasonmotley]

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

[@learnspreadsheets]

it gets tricky with permissions, but yes it should work

[@spdby]

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

[@spdby]

@@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

[@masadi1980]

thanks

[@learnspreadsheets]

No worries!

[@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

[@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

[@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

[@larsenmoura2427]

This is some of the worst instructions I’ve ever seen in my life please find a new job

[@learnspreadsheets]

I'm sorry you feel that way but many, many other comments seem to say the opposite, so I think for the most part, people find it helpful.

[@ahmetkarslgil2268]

You didn't make the first version you show. What a waste of time