Charts in Google Sheets - Full Tutorial

Learn all the basics about charts including which type of chart to use. We will cover pie charts, line charts, geo charts, and more.
🕒 Timestamps:
0:00 Choosing which chart
10:08 Whole to whole comparison - Pie chart
3:04 Bad data - just one state
6:57 Large data set
7:23 Pivot table
10:13 May maps
12:57 Automate your work
Learn more from Prolific Oaktree:
🌳 Next Video - Google Drive - Free vs Paid Versions • Google Drive - Free vs...
🌳 Related Playlist - Google Apps | Full Tutorials - bit.ly/google-...
#googlesheets #graphs #charts

[@DLJevcc]

I got enough to do what I needed to do in the first 10 minutes. I know the rest is worth watching, especially as I want to get more sophisticated results. This was a really excellent walkthrough. Thank you!

[@lucdelor303]

Thanks for the tutorial. Your videos and style brings peacefulness and understanding.

[@ProlificOaktree]

I'm glad it made you feel that way. I tried something different with the charts videos and it was quite a joy to make them.

[@deetsbay495]

I'm really enjoying and learning from your videos. Love from India!!!!

[@ProlificOaktree]

Right back at you ChiranGV.

[@user-bq5mo7hd6n]

If you were to take the time series at around 26 minutes, but have both circumference and height, how would you graph that data over time?

[@dustinm800]

How do I overlay a text box over a chart and force it to the front? Is there a way to group a text box with a chart? Thanks

[@revilotnek1610]

Hi! How do I anchor or lock in place the chart like when freezing rows and columns, the chart won't be moved to other cells? Thanks so much:)

[@ProlificOaktree]

You're best off just putting in a part of the spreadsheet that doesn't move around much.

[@revilotnek1610]

@@ProlificOaktree
Thank you Sir. Unfortunately, the chart I'm using will be best positioned on top, so I figured not to freeze the upper rows. I hope the Google team will find a way to resolve this.:)

[@AshishKumar-xg6hi]

Hi ,
I have created charts from my spreadsheet data . I am updating my data in the spreadsheet everyday . But it is not showing in the chart. How can my spreadsheet data be automatically reflect in the chat (As I update in spreadsheet).
For example, I have created the chart on 28/October/2022 for the data(19/oct/2022 to 28/oct/2022).
But when I entered data for 29/oct/2022 , it is not coming in the chart, how can I fix this?

[@ProlificOaktree]

One idea is to take the ending row number off of the chart’s range like A1:C.

[@AnkitaRazdan]

explore option is no more available

[@ProlificOaktree]

I won't miss it personally. It seemed helpful, but I never remembered it.

[@dulzkyriveratovitch256]

This tutorial is for teen agers no offense. How about teaching us on how to handle big data. Like you have like 38 tree types then you will make a top bar chart on the most number of trees then put top 11 to 38 on others at the bottom of the chart something like that

[@ProlificOaktree]

Once you get more detailed, the variations in what people are looking for would create a very, very long video.