Nov 25, 2015

Google Apps: Embedding Google Sheets Charts

I recently asked the middle school to identify the background image of the School Site. To capture responses I used a Google Form, requiring respondents to be logged in to their school GAFE account and limited their responses to only one. This reduced the chance of a vote brigade and also gave us more information should we wish to further analyze the results.

Once the poll was closed we could create a simple pie chart to share the responses on the School Site. Creating a chart was as simple as highlighting the column of guesses, clicking the Insert chart icon on the tool bar, choosing pie chart. There are a few options to personalize the chart, including presentation (flat or 3d), section colors, font color and size, background color, and aggregate type. While not as robust as Excel, there are just enough features for those learning to represent data.

To embed a chart:
  1. Click the little arrow in the upper right corner of the chart box.
  2. Choose Publish chart.
  3. Select the Embed tab.
  4. Choose whether or not the chart will be interactive or an image.
  5. Click Publish.
  6. Copy/paste the embed code to your page.

I like that the embedded chart offers some interactivity -- when you hover or click on the chart or legend, a small pop-up identifies the response and percentage. I also like that changes to data or chart style can be automatically pushed out to the embed.

What I don't like is that the order of items in the legend can not be changed (responses are listed alphabetically). It doesn't matter how the data is sorted in Sheets, there is no way to reorder in advanced settings.