It shows all right but brings me to another issue I created a chart and embedded it in HTML And also displayed it as table query using the URL within
http://docs.google.com/spreadsheet/tq?key=0Am19V2tYPHDHdE1wbG5QLVJ2NUowUTBrODFGc3REbVE&transpose=0&headers=0&range=A1%3AD1&gid=0&pub=1 But then when I changed the data in the spreadsheet it was not updated in the table query nor in the chart, so no matter how often the chart in HTML is refreshed the data is not refreshed So back to the method I use today.I use Python and PHP to extract the cell values and return it and build the chart on the fly, for charts that I want to show immediate changes, and use your proposed method for charts I do not need to show immediate udpats *Roni Segoly * *+972-54-6466264* * <http://s.wisestamp.com/links?url=tel%3A%252B972-54-6466264&sn=cm9uaS5zZWdvbHlAZ21haWwuY29t>*יוזמה פרויקטים חברתיים וסביבתיים בע"מ <http://www.yozma.net/> Yozma - social & environmental projects <http://www.yozma.net/> Google+ Page [image: Google Plus Page] <https://plus.google.com/u/0/+RoniSegoly/about> * <http://en.wikipedia.org/wiki/Mohandas_Karamchand_Gandhi>* On Wed, Jun 25, 2014 at 9:54 AM, Roni Segoly <[email protected]> wrote: > Will try again today > > Roni Segoly > 0546466264 > On 24 Jun 2014 21:04, "Andrew Gallant" <[email protected]> wrote: > >> It works for me: http://jsfiddle.net/asgallant/DPET3/ >> >> On Tuesday, June 24, 2014 1:10:08 PM UTC-4, Roni Segoly wrote: >>> >>> If I add it, it will not display at all. >>> >>> >>> >>> >>> >>> >>> *Roni Segoly * >>> >>> *+972-54-6466264 <%2B972-54-6466264>* >>> >>> >>> * >>> <http://s.wisestamp.com/links?url=tel%3A%252B972-54-6466264&sn=cm9uaS5zZWdvbHlAZ21haWwuY29t>*יוזמה >>> פרויקטים חברתיים וסביבתיים בע"מ <http://www.yozma.net/> >>> >>> Yozma - social & environmental projects <http://www.yozma.net/> >>> >>> >>> >>> >>> Google+ Page [image: Google Plus Page] >>> <https://plus.google.com/u/0/+RoniSegoly/about> >>> >>> * <http://en.wikipedia.org/wiki/Mohandas_Karamchand_Gandhi>* >>> >>> >>> On Tue, Jun 24, 2014 at 7:36 PM, Andrew Gallant <[email protected]> >>> wrote: >>> >>>> 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/aja >>>>> x/static/modules/gviz/1.0/chart.js"> >>>>> {"dataSourceUrl":"//docs.google.com/spreadsheet/tq?key=0ArVG >>>>> QYDunAPqdEFiMFZuZTJGXzd4Zm55a3ZlcUd0ZGc&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":"","boolea >>>>> nRole":"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","chartN >>>>> ame":"Chart2"} >>>>> </script> >>>>> >>>> -- >>>> You received this message because you are subscribed to a topic in the >>>> Google Groups "Google Visualization API" group. >>>> To unsubscribe from this topic, visit https://groups.google.com/d/ >>>> topic/google-visualization-api/Jqvk7dytThc/unsubscribe. >>>> To unsubscribe from this group and all its topics, 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. >>>> >>> >>> -- >> You received this message because you are subscribed to a topic in the >> Google Groups "Google Visualization API" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/google-visualization-api/Jqvk7dytThc/unsubscribe >> . >> To unsubscribe from this group and all its topics, 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. >> > -- 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.
