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…
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Protecting sheets against unwanted changes
- Rearranging rows and columns
- Adding data validation to cells
- Using the image function to easily add images to cells
- Inserting a gauge chart for status updates
- Adding estimate data to Google charts
- Publishing charts to a website
- Using Google Forms to create surveys
- Using Google Sheets add-ons