How can I publish a google chart in Confluence?

[giulia.russi]

Hello,

I would like to publish a chart from a google sheet in Confluence, so that when the sheet is updated, so is the chart. Is this possible, and if so how?

Thanks

[szabolcs.szepesi · Accepted solution]

Hello!

In Sheets, when you created the chart you want to share, click the three dots in the upper right corner. Then choose "Publish chart" and click "Embed"'.

Copy the url address from the "src" part of the iframe and paste to the iframe macro in Confluence.

This iframe macro works pretty well, if not, try replacing "http" in the url with "https".

[Nikki Leonard]

This is very helpful and works well. Thank you. 

To take this one step further, when the data is updated for the source chart how can you ensure the change will be reflected on the confluence page iframe version? 

example: we have a chart for that shows a count. when that count changes in the spreadsheet/chart, we'd like it reflected in the chart embedded on confluence. 

Thanks in advance! 

[Nikki Leonard]

Answered my own question here. When you are getting the embed link in sheets, select "automatically replenish changes.." checkbox. Works like a charm. 

[Andrey Khaneev _StiltSoft_]

Hello Giulia,

As far as I know there it is not possible to do with Confluence itself, but there are some apps that possibly can do it.

[giulia.russi]

Thank you!