Re: [visualization-api] Opening a subset of sheet for editing
Hi Bart, It appears that the nice simple way to edit a single row of a spreadsheet did not involve Google Charts, though you might use a query to find out which row you'll want to edit. I don't see how would send any changes back to the spreadsheet, not without the equivalent of what you get with Forms or Google Site. The playground page referenced in that article is now gone, which would have helped to figure out how it was done. The range parameter still works. See docs on https://developers.google.com/chart/interactive/docs/spreadsheets Can you give an example of how you are trying to use it? If you could build a jsfiddle example to point to, that would make your usage sufficiently clear. On Fri, Jan 9, 2015 at 11:01 AM, Bart Bremmers bart.bremm...@craft-bilt.com wrote: There was a nice simple way to present the user with a single row for editing https://mashe.hawksey.info/2013/07/how-to-open-a-google-spreadsheet-at-a-specific-row-for-editing/ using the old sheets with List View Is there way to achieve something similar in the new sheets using query parameters? I have been playing around with query strings in .../gviz... url's, but they only return flat html or csv type results, not editable I also tried adding query parameters to .../edit... url's but you can guess the results :( We have already ruled out using Forms, since we are using several connected sheets with formulas. Creating a Google Site with editable fields is beyond my ability, looks like it requires quite a bit of scripting including Atom feeds about which I have no clue. As an aside, I have not been able to get ?range= to work no matter how I try, is this deprecated? Thanks -- 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 google-visualization-api+unsubscr...@googlegroups.com. To post to this group, send email to google-visualization-api@googlegroups.com. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout. -- Daniel LaLiberte https://plus.google.com/100631381223468223275?prsrc=2 - 978-394-1058 dlalibe...@google.com dlalibe...@google.com 5CC, Cambridge MA daniel.lalibe...@gmail.com daniel.lalibe...@gmail.com 9 Juniper Ridge Road, Acton MA -- 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 google-visualization-api+unsubscr...@googlegroups.com. To post to this group, send email to google-visualization-api@googlegroups.com. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.
Re: [visualization-api] Opening a subset of sheet for editing
Thanks for the reply Daniel Regarding the range parameter I think your link https://developers.google.com/chart/interactive/docs/spreadsheets uses the old url syntax. https://docs.google.com/a/google.com/spreadsheet/ccc?key=12345range=A1:C4; I have been playing with url strings that look like: https://docs.google.com/a/craft-bilt.com/spreadsheets/d/[key]/gviz/tq?tqx=out:htmlrange=5 as well as many other variants Please let me know what syntax I should be using -- 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 google-visualization-api+unsubscr...@googlegroups.com. To post to this group, send email to google-visualization-api@googlegroups.com. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.
[visualization-api] Is there a way to create phase lines?
Is there a way to create a phase line, multiple ones hopefully. I need to look at a chart, and have a vertical phase line of when some event occurred. Here's an example: -- 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 google-visualization-api+unsubscr...@googlegroups.com. To post to this group, send email to google-visualization-api@googlegroups.com. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.
[visualization-api] Newbie, testing an example for tree charts,
I'm comparing implementing google charts versus d3.js. Right away I like how each example details the required input *data format* [1] for the visualization. On the Tree Map Charts page is a link to a JSfiddle example [2] which worked fine for me. However, when I attempted to add my own node data, the chart does not render. [3]. I threw the same values into a Tableau tree chart, which displayed fine. https://lh4.googleusercontent.com/-Ayaiqz1FICo/VLBWAFLn5OI/Ars/g-wzrtFdE_8/s1600/Dashboard%2B1.jpg Any idea why my version of Google Tree Map Chart doesn't display? C [1]: https://developers.google.com/chart/interactive/docs/gallery/treemap#Data_Format [2]: http://jsfiddle.net/api/post/library/pure/ [3]: http://jsfiddle.net/0vdazehy/11/ -- 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 google-visualization-api+unsubscr...@googlegroups.com. To post to this group, send email to google-visualization-api@googlegroups.com. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.
Re: [visualization-api] Annotated Timeline Chart
Here is an example that uses checkboxes to select which series to show: http://jsfiddle.net/dlaliberte/a3cgLkq6/ This is for a LineChart, but something similar will work with the AnnotationChart. On Wed, Jan 7, 2015 at 5:11 AM, Enkhtuvshin Amgalanbayar enkhtuvshi...@gmail.com wrote: *Hello Daniel.* *This is the script we have right now and it is working well thanks to your help. you can see from the attached picture.* script type=text/javascript src= https://www.google.com/jsapi?autoload={'modules':[{'name':'visualization ','version':'1.0','packages':['annotationchart']}]}/script script type='text/javascript' google.load('visualization', '1.0', { 'packages': ['annotationchart'] }); google.setOnLoadCallback(drawChart); function drawChart() { var query = new google.visualization.Query( ' https://docs.google.com/spreadsheets/d/1lb_pUshsx4Cy1layoy8WRfgpXLgOBYSSBSRt9e3YmB4/edit#gid=0range=A:C' ); query.send(handleQueryResponse); } function handleQueryResponse(response) { if (response.isError()) { alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage()); return; } var data = response.getDataTable(); var chart = new google.visualization.AnnotationChart(document.getElementById('annotationchart')); chart.draw(data, { displayZoomButtons: true, displayAnnotations: true, zoomButtonsOrder: [ '1-week', '1-month', '3-months', '6-months', '1-year', 'max'], zoomStartTime: new Date(2013, 01, 01), //colors: ['red'], dateFormat: '/MM/dd', //displayAnnotationsFilter: true, allValuesSuffix: '₮', thickness: '2', scaleColumns: [0, 2], scaleType: 'allmaximized', fill: 10, //legendPosition= ('newRow') }); } /script div id='annotationchart' style='width: 600px; height: 400px;'/div *And this is the script we have for the HTML checkbox* form action= input type=checkbox name=Dollar value=$USD input type=checkbox name=Euro value=EEUR input type=checkbox name=Renminbi value=ECNY input type=checkbox name=Pounds value=EGBP *Unfortunately we are unable to connect our Checkboxes with our graph.* *please share with us if you have any suggestions.* *Thank you * -- 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 google-visualization-api+unsubscr...@googlegroups.com. To post to this group, send email to google-visualization-api@googlegroups.com. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout. -- Daniel LaLiberte https://plus.google.com/100631381223468223275?prsrc=2 - 978-394-1058 dlalibe...@google.com dlalibe...@google.com 5CC, Cambridge MA daniel.lalibe...@gmail.com daniel.lalibe...@gmail.com 9 Juniper Ridge Road, Acton MA -- 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 google-visualization-api+unsubscr...@googlegroups.com. To post to this group, send email to google-visualization-api@googlegroups.com. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.
Re: [visualization-api] word tree is not workin in IE9 and below
Hi Vishal, the Google Word Trees generate SVG but not VML, which means they won't work on very old browsers (IE8 and previous versions). Sorry! Jon On Fri, Jan 9, 2015 at 1:18 AM, Vishal Kamble vishalkamble8...@gmail.com wrote: Hello, I am facing problem related to word tree. this chart is not working properly in IE8 and Below. Please help me to solve this problem. it is working properly on Chrome, Firefox and IE9 and above. -- 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 google-visualization-api+unsubscr...@googlegroups.com. To post to this group, send email to google-visualization-api@googlegroups.com. 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 google-visualization-api+unsubscr...@googlegroups.com. To post to this group, send email to google-visualization-api@googlegroups.com. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.