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!!
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
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??
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
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
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 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
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 🤣
Thank you so much for the efforts in doing this video, it is really amazing
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 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
Glad it helped! Yay
Thanks a lot for this simple yet powerful explanatory tutorial
Thanks so much for the comment! I'm glad you like it
Thanks David, LOVE IT! This is very helpful. Enjoy your vidoes.
Thanks so much! That’s awesome 😃
Awesome Man!!!!!!
Haha what a great emoji! Glad you like that video 😃
Great video! I have definitely found most of the charts I wanted to use all in one video. Thanks for this.
Nice one!
Thank you for this video! it interested me a lot and helped me too
Im glad you liked it!
Literally the most helpful video!! Thank you!
Glad you like it!
This is really good!
Glad you find it useful 😃
Thanks! Just what I was looking for. 😊
Thanks for saying that - very kind!
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??
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
Very usefull information, thank you for this video!
Ya thanks!
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
Useful, thank you very much ^^
Glad you like it!
I'm trying to test if the Dashboard works when "Published to the Web" ... Does it? Doesn't seem to work for me.
it gets tricky with permissions, but yes it should work
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
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!
THANKS
Glad you like it!
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
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
thanks
No worries!
voice like a Head Space instructor
Hahaha thanks! I think! I like that guy he’s pretty calming 🙃
@@learnspreadsheets exactly, very calming. Thank you for sharing your knowledge
This is some of the worst instructions I’ve ever seen in my life please find a new job
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.
You didn't make the first version you show. What a waste of time