How to Create a Dynamic Chart in Google Sheets Using Google Forms


Get Shift Done: Tips and Tricks

Google Forms is an extremely handy application in the Google Drive suite. You can use Forms to collaborate on documents, transfer files to other users, and create web forms that submit the data right into a Google Spreadsheet. But Google Forms are even more powerful when you integrate them with Google Sheets.

For example, you can create a Google Form that automatically saves the data collected into a Google Spreadsheet. The obvious benefit is collecting the results into a single spreadsheet for your own analysis or what-have-you. However, the form/spreadsheet integration can help you create a dynamic chart that updates each time with every new form entry.

Let’s say, for example, we are managing a charity fundraising website that includes a request for the site visitor to make a pledge for a donation. Each sponsor can fill out the fields in the Google Form, pledging the amount of money to donate. So far, so good. However, in addition to a list of sponsors and their contact information, we would like to track how much money has been donated, and what regional location is raising the most — ideally with some sort of visual to show progress.

Read More