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".
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!
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! Just what I was looking for. 😊
Thanks for saying that - very kind!
Very usefull information, thank you for this video!
Ya thanks!
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
This is really good!
Glad you find it useful 😃
Useful, thank you very much ^^
Glad you like it!
Awesome Man!!!!!!
Haha what a great emoji! Glad you like that video 😃
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 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 🤣
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
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
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
thanks
No worries!
yh
Yup
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
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
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 David, LOVE IT! This is very helpful. Enjoy your vidoes.
Thanks so much! That’s awesome 😃