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'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!!
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
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
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".
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'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!
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 🤣
Great video! I have definitely found most of the charts I wanted to use all in one video. Thanks for this.
Nice one!
Literally the most helpful video!! Thank you!
Glad you like it!
Thanks David, LOVE IT! This is very helpful. Enjoy your vidoes.
Thanks so much! That’s awesome 😃
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
Thanks! Just what I was looking for. 😊
Thanks for saying that - very kind!
Very usefull information, thank you for this video!
Ya 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!
I'm trying to test if the Dashboard works when "Published to the Web" ... Does it? Doesn't seem to work for me.
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
This is really good!
Glad you find it useful 😃
Awesome Man!!!!!!
Haha what a great emoji! Glad you like that video 😃
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
Useful, thank you very much ^^
Glad you like it!
THANKS
Glad you like it!
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
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