Skip to main content

I’ve finally figured it out - it’s only taken me about two and a half years!

How to create a ‘radar’ chart in Google Sheets for a report - based on Typeform submission. Or any other graph that is.

Here’s the use case - or at least one of them:

You are using a scoring quiz to evaluate some aspect of the respondent and want to show a graph of the output. Say, 5 categories of an assessment or something similar.

You want to send them a customized document after they submit their data, complete with a graph of the results.

Here’s the toolset:

  • Typeform
  • Google Sheets
  • Document Studio (yeah that one again, lol)

If you don’t have Document Studio, I strongly recommend getting it as it will help generate a lot of customized reports from your Typeform data - pushed into a merge template, converted into PDF format and attached to an email.

Now I will be honest - I have not explored all the formatting options inside the Google Sheet charting options. BUT I wanted to get this wee bit of a note out to you folks while the seven other voices in my head are doing the happy dance.

In any event, let’s check it out.

I want to turn this input from my typeform:

 

into a PDF report with graphs that look like these:

 

That's a screenshot of the PDF file - a really simple example of a dynamic report - that shows a 'customized report' for the respondent complete with the two different graph types.

I can't believe it took me over two years to figure this out!

I've put all the steps into ​this Google Doc​ - saving screen real estate - for you.

There's also a video for this ​at this link​

Check these out and let me know!

Hopefully you haven't been waiting for two years to figure this out.... 

Cheers

des

Amazing @john.desborough! You conquered Everest! 🎉 

@Liz is gonna love this one when she’s back from vacation! 👀


Awesome sauce @john.desborough very happy to hear that you and the other voices smashed this one. It’s certainly a hugely useful technique to have in the locker 🤘

 

 


@Grace @James - i don’t know how many times I’ve tried to get the radar charts to work and this solution just seemed to be so easy… it will take time for the marks from beating my head on the wall to disappear but I am quite chuffed about this.. 

 

des


So you should be @john.desborough nice work! 💫


Reply