Monday, January 25, 2016

Google Sheet Motion Charts

So often we see bar charts and pie charts.  Why not try motion charts?  This makes your charts come alive and truly communicate what you are trying to get across to your audience.  Here is an example of how you can take data collected on population growth in 3 Central Texas counties.

  1. Type your data in Google Sheets like this.

  2. Highlight all the data displayed.
  3. Click Insert>Chart.
  4. Select the Chart types tab.
  5. Select only Use row 1 as headers.
  6. Scroll down and click the motion chart.
  7. Click the Insert button.

  8. Change Population to Time on the chart.
  9. Select your color, size, and counties as needed.
  10. Click Play to see the awesome results.