I suspect that all you need to do is add a "refreshInterval" property to
the object in the script tag:
<script type="text/javascript"
src="//ajax.googleapis.com/ajax/static/modules/gviz/1.0/chart.js">
{"dataSourceUrl":"//docs.google.com/spreadsheet/tq?key=0ArVGQYDunAPqdEFiMFZuZTJGXzd4Zm55a3ZlcUd0ZGc&transpose=0&headers=1&range=B1%3AI104&gid=9&pub=1","options":{"titleTextStyle":{"bold":true,"color":"#000","fontSize":16},"vAxes":[{"title":null,"useFormatFromData":true,"minValue":null,"viewWindow":{"min":null,"max":null},"maxValue":null},{"useFormatFromData":true,"minValue":null,"viewWindow":{"min":null,"max":null},"maxValue":null}],"title":"\u05e9\u05d3\u05d4
\u05d1\u05d5\u05e7\u05e8
\u05d5\u05d2\u05d3\u05e8\u05d5\u05ea","curveType":"","booleanRole":"certainty","height":371,"animation":{"duration":0},"legend":"right","width":600,"lineWidth":2,"hAxis":{"useFormatFromData":true,"minValue":null,"viewWindowMode":null,"viewWindow":null,"maxValue":null},"tooltip":{}},"state":{},"view":{},"isDefaultVisualization":false,"chartType":"LineChart","chartName":"Chart2"
,"refreshInterval":60}
</script>
refreshInterval takes an integer for the number of seconds between updates.
On Tuesday, June 24, 2014 6:04:40 AM UTC-4, Roni Segoly wrote:
>
> Google spreadsheet enable publishing charts as images or interactive
> scripts such as the example at the bottom
>
> When I include the script in HTML it is displayed as expected, but not
> updated at all or after many minutes
> In this page I included HTML refresh which is ugly solution
> http://212.150.200.169:84/combo3.php
>
> I can build the charts on my HTML page but when I need lots of data or
> nice design features it's easier to build on the sheet itself
>
> I have the below example where chart is built in PHP page and only data
> is retrieved and then refreshed and it's nice solution
> http://212.150.200.169:84/g.php
>
> So the question
> For the below script can I use draw function based on the content of the
> script? For me it's Greek
>
>
>
>
> <script type="text/javascript" src="//
> ajax.googleapis.com/ajax/static/modules/gviz/1.0/chart.js">
> {"dataSourceUrl":"//
> docs.google.com/spreadsheet/tq?key=0ArVGQYDunAPqdEFiMFZuZTJGXzd4Zm55a3ZlcUd0ZGc&transpose=0&headers=1&range=B1%3AI104&gid=9&pub=1","options":{"titleTextStyle":{"bold":true,"color":"#000","fontSize":16},"vAxes":[{"title":null,"useFormatFromData":true,"minValue":null,"viewWindow":{"min":null,"max":null},"maxValue":null},{"useFormatFromData":true,"minValue":null,"viewWindow":{"min":null,"max":null},"maxValue":null}],"title":"\u05e9\u05d3\u05d4
>
> \u05d1\u05d5\u05e7\u05e8
> \u05d5\u05d2\u05d3\u05e8\u05d5\u05ea","curveType":"","booleanRole":"certainty","height":371,"animation":{"duration":0},"legend":"right","width":600,"lineWidth":2,"hAxis":{"useFormatFromData":true,"minValue":null,"viewWindowMode":null,"viewWindow":null,"maxValue":null},"tooltip":{}},"state":{},"view":{},"isDefaultVisualization":false,"chartType":"LineChart","chartName":"Chart2"}
> </script>
>
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/d/optout.
