Results in PDF: How to create a chart in Google slide from Google Spreadsheets

Hi @Rosemary Lovely name! Welcome to the community! I believe @john.desborough has more experience setting this up than I do and may be able to offer you some pointers. :) 

Thank you, I would love to hear @john.desborough 's experience and tips if he has some! :)

@Liz @Rosemary  - funny you should ask this at the moment. I am working on this solution for a client. I will post one possible approach to solving this later this evening after i finish off some client work and end of day parental responsibilities.. 

des

@john.desborough what a nice coincidence . I am very much looking forward to reading the possible solution. Thanks in advance!

Thanks in advance, @john.desborough !

@Rosemary @Liz -- sometimes life and the need for another coffee get in the way. 

here is a simple example of how you can make it work… have a peek while i do some other client work and drink another/the inevitable coffee lol.. 

oh.. you will have to enter a valid email address to see the example. 

cheers

des

@john.desborough This is exactly what I had in mind . Maybe I am missing something, but my question is, how do I create this myself? I have made the Typeform, and connected it to Google spreadsheets and then to Google slides, using Document studio. I don't know how to get the graph? Oh, and enjoy the coffee :)  

@Rosemary - here’s a short video that shows how it was done .. there are a few things that i included for folks who have not managed to use Document Studio before but hopefully you can see how this is done..

full transparency: this ‘spoofs’ a bar chart (creating a ‘canned’ image that is fed data based on a filter for the current row only that dynamically updates the chart embedded in a Google Slide IS possible, but is a complicated little beast.. this is an easier approach) 

@john.desborough Thank you very much, you absolutely rocked my day! :) 

Thank you, @john.desborough !! Glad this helped, @Rosemary !