Google Sheets Challenge 12 - Data Visualization
Vložit
- čas přidán 6. 07. 2024
- In this video, I give you four questions from easy to hard to test your knowledge of Data Visualization in Google Sheets.
Also be sure to leave a comment below to let me know how you do!
DOWNLOAD LINK
docs.google.com/spreadsheets/...
ARTICLES
spreadsheetlife.com/too-much-...
spreadsheetlife.com/when-to-u...
spreadsheetlife.com/what-is-a...
spreadsheetlife.com/gs-challe...
RESOURCES
Templates: spreadsheetlife.com/spreadshe...
Blog: spreadsheetlife.com/blog/
VIDEO CHAPTERS
00:00 - Intro
00:30 - Question 1
01:30 - Question 2
02:37 - Question 3
03:57 - Question 4
04:54 - Outro
NO PIE!!! haha, I love that!
Google Sheets trips me up sometimes! I knew that Q3 would need a histogram, but I couldn't for the life of me find it! I'm glad I know where it is now! Same with the trend line in Q4. Thanks for making these and helping me get familiar with Google Sheets!
I love your tutorials - all the best
Question - (not sheets!!!) - what is the transition you use at 1:28 called - what are you using to create that - I would like to use that when switching from one window/tab to another.
TIA - and good luck
Thank you so much!
For your question. That transition was actually something I put in to the video after I finished screen recording. So it's not something I did to switch between tabs.
I use Camtasia for my screen recording and editing. I hope this helps to answer your question.
was the dates in x axis in the wrong format in question 3? btw loved the videos
You make an awesome point. That's actually a small mistake on my part. It would have been better to just select the Units Sold numbers and not the dates since they are not needed for this chart. Although selecting them did not harm the final result. However, I should have deleted the title for the X-Axis which reads "Date" since the dates are not on the x-axis. The x-axis is simply different bucket sizes for the histogram. Sorry I missed that little detail in the video, but thank you for asking about it. 😊👍
@@spreadsheetlife hehe😁.expecting more videos from you.keep up the good work☺
Thank you so much! I'll do my best! 😄