In this video, author Jess Stratton shows users how to add a chart made from Google Sheets to a website, and preserve the interactive elements of the chart.
- In a previous video, I showed you…how to create a chart from Google Sheets.…We created one for pledges, donations,…and we also created a geo-chart,…based on where people were coming from…at a conference.…I can hover my mouse over the chart…and I can see the count of all the registrants.…Let's take these charts a step further.…I'm going to show you how easy it is…in Google Sheets to add this chart to a website.…Let's start with the pledges.…Click on the chart once and in the drop down arrow…that appears on the top right, click on it…and choose publish chart.…
Instead of creating a link to this chart…I'm going to click the embed tab.…I want this chart to be embedded onto my web page.…I'm going to click to expand…the publish content and settings.…Instead of publishing the entire document,…I'm going to uncheck the word entire document…and instead I'm only going to put my chart on there.…I'll find my pledges chart…and put a check box beside that.…This next step is key, especially for something…like a pledge drive in which we used…
- Explain why it is beneficial to use a template spreadsheet in Google Sheets rather than start from scratch.
- Name the action you would need to take to make data fit in a column on a Google sheet.
- List the steps to include multiple lines in a cell.
- Explain how to use the iframe code for a chart when publishing it to a website.
- Recall the main advantage of using IFTTT services with Google Sheets.
- Recognize situations where Google Sheets email notifications would be useful.