Cool graph features in Google Sheets that you didn’t know about

What easy options are there for portraying your data beyond the standard pie chart and line graph? Turns out there are more than you might think. With the right kind of data, Google Sheets lets you create choropleth maps, tree maps, and motion charts. Check out the examples below, and video tutorials on how to make your own!

Choropleth Maps

sample chloropleth map

Tree Maps

sample tree chart

Motion Charts

Motion charts are interactive – try manipulating the colour of the dots, indicated if you want to see “trails” of movement, and whether you look at a dots or a bar graph, then press play under the chart area to see the changes over time.

**the video below is a bit dated so some aspects of the interface have changed, but you get the general idea

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s