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

Canadians will have free online access to research funded by NSERC, SSHRC and CIHR

Effective May 1st, 2015, “the harmonized Tri-Agency Open Access Policy on Publications requires all peer-reviewed journal publications funded by one of the three federal granting agencies to be freely available online within 12 months. Canada’s three federal granting agencies are: the Canadian Institutes of Health Research (CIHR), the Natural Sciences and Engineering Council of Canada (NSERC), and the Social Sciences and Humanities Research Council of Canada (SSHRC)”. (1)

1.    Minister Holder Announces New Open Access Policy for Research [press release]. February 27, 2015.