Data Visualization for Beginners in Google Sheets
🚀Join my free tech newsletter: https://got-sheet.beehiiv.com/
Spreadsheets are extremely useful in 📊visualizing large data sets quickly. I walk through how to create bar and pie charts in Google Sheets, how to filter data for use in the charts and towards the end show you how to publish the charts to the web for free.
►Here's the demo spreadsheet of video game sales data we're using in this walkthrough: https://docs.google.com/spreadsheets/...
►Here's an article I wrote about the topic for freeCodeCamp: https://www.freecodecamp.org/news/dat...
We receive commission on purchases made through some links on this page
_______________________________________________
🎓Software Recommendations:
► Starting a Newsletter? Check out Beehiiv with a free trial and 20% off your first 3 months: https://www.beehiiv.com/?via=eamonn
► ConvertKit - creator marketing & newsletter platform - https://partners.convertkit.com/358pj...
► HubSpot free CRM software for sales, marketing, customer service, operations teams. https://hubspot.sjv.io/c/4186908/1001...
► Notion - productivity & note-taking app - https://affiliate.notion.so/p7771a8zwlsu
► Carrd - one page landing sites - https://try.carrd.co/s4x1c97b
► Coefficient - import data and sync with your business systems in Google Sheets - https://coefficient.io/?via=984f9f
_______________________________________________
🎓Data Course Suggestions: (coursera)
► Advanced Data Analytics Certificate by Google: https://imp.i384100.net/21dWGa
► Microsoft Power BI Data Analyst Certificate - https://imp.i384100.net/4PgjK3
►Microsoft Business Analyst Certificat - https://imp.i384100.net/anamAq
► Cybersecurity by Google: https://imp.i384100.net/VmN6oM
► Google Cloud Data Analytics Certificate - https://imp.i384100.net/B0ZJb0
_______________________________________________
🎓AI Course Suggestions: (coursera)
► IBM AI Developer Certificate - https://imp.i384100.net/B0ZR9L
► Overview IBM AI Engineer Certificate - https://imp.i384100.net/KjnyA9
► Google AI Essentials - https://www.coursera.org/learn/google...
_______________________________________________
🖥️ Office items I can't live without:
https://amzn.to/3uqSO7Q (amazon)
📲 Find me
on LinkedIn: / eamonncottrell
on Twitter: / eamonncottrell
_______________________________________________
Chapter Markers:
00:00:00 - Intro
00:00:38 - Filter Views
00:01:24 - Create Column Chart
00:02:15 - Setup Data
00:03:24 - Customize Chart
00:03:42 - Chart and Axis Titles
00:06:04 - Legend
00:06:19 - Horizontal Axis
00:06:37 - Vertical Axis
00:06:44 - Gridlines
00:07:27 - Reposition Chart
00:08:04 - Pie Chart Setup
00:09:05 - Customize Pie Chart
00:11:05 - Publish Chart to Web
00:12:12 - Stop Publishing
00:12:27 - Use Filters for Charts
00:13:45 - Fixes to Filter Issues
Watch video Data Visualization for Beginners in Google Sheets online without registration, duration hours minute second in high quality. This video was added by user Eamonn Cottrell 14 March 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 10,689 once and liked it 105 people.