Insert graphs obtained in a form in a google document

Skip to first unread message

Francisco Moreno

Nov 29, 2022, 1:17:32 PM11/29/22
to Google Apps Script Community
Do you know if it is possible insert the graphs displayed by a form in the "Answers" tab in a google document, automating the task with Apps Script?

Dec 1, 2022, 7:29:47 AM12/1/22
to Google Apps Script Community
Not specifically with Apps script. It doesn't look like those charts are part of the FormsApp. However, you might be able to replicate the Pie charts simply by linking the form to a Sheet, and charting the responses in another tab in the spreadsheet.
Then for each answer, copy the chart, and paste into the Doc making sure you select "Link to Spreadsheet" so the chart updates as responses come in.

Reply all
Reply to author
0 new messages