You should leave the "key" alone in the query's URL (that is what identifies the specific spreadsheet). All other parameters you can change as you like.
On Wednesday, March 27, 2013 9:46:47 AM UTC-4, SJO wrote: > > Is it safe to manipulate just the querystring variables to generate an > image or is it possible the encoded part may change? (which I assume is the > document reference) > > Thanks > > > > On Monday, March 25, 2013 3:04:37 PM UTC, trybka wrote: >> >> This version of the fiddle uses a copy of the spreadsheet because I >> wanted to be able to play around and not affect yours, that's all. >> >> Thomas Rybka | Software Engineer | [email protected] | GViz >> >> >> On Mon, Mar 25, 2013 at 11:00 AM, SJO <[email protected]> wrote: >> >>> Thanks Thomas. That's perfect. I'll have a play with it! >>> >>> I don't understand about making my sheet more readable? :-) >>> >>> >>> >>> On Monday, March 25, 2013 2:43:51 PM UTC, trybka wrote: >>> >>>> With regards to the size, there is a 300,000 square pixel max on the >>>> size. >>>> >>>> 547x547 is the max square size (548x548 = 300,304). >>>> >>>> More info here: https://developers.**google.com/chart/image/docs/** >>>> chart_params#gcharts_chs<https://developers.google.com/chart/image/docs/chart_params#gcharts_chs> >>>> >>>> In terms of a workaround for plotting X-axis values on the >>>> ImageLineChart, you can use a "view" with the ChartWrapper to make that >>>> first column look more like a set of labels: >>>> >>>> Here's a jsfiddle: >>>> http://jsfiddle.net/**NVNh6/4/<http://jsfiddle.net/NVNh6/4/> (I >>>> also fixed the URL to use a hopefully more readable copy of your >>>> spreadsheet). >>>> >>>> >>>> >>>> >>>> Thomas Rybka | Software Engineer | [email protected] |** Google >>>> >>>> Thomas Rybka | Software Engineer | [email protected] |** GViz >>>> >>>> >>>> On Mon, Mar 25, 2013 at 4:59 AM, SJO <[email protected]> wrote: >>>> >>>>> Thanks Thomas. That seems to work well. >>>>> >>>>> Can you think of any workaround with regards to plotting X axis with >>>>> ImageLineChart? Also any idea why specifying a width/height of 1000 >>>>> actually ends up being 547px? >>>>> >>>>> Regards >>>>> >>>>> >>>>> >>>>> >>>>> On Friday, March 22, 2013 2:42:28 PM UTC, trybka wrote: >>>>> >>>>>> 1) Here's a jsfiddle for the LineChart: http://jsfiddle.**net** >>>>>> /NVNh6/1/ <http://jsfiddle.net/NVNh6/1/> >>>>>> I set useFirstColumnAsDomain: true to get the intended value. Note >>>>>> the dataSourceUrl has range specified in it to pick out the cells that >>>>>> have >>>>>> data in them. >>>>>> >>>>>> Full docs for using Google Spreadsheets as a data source URL: >>>>>> https://developers.**google**.com/chart/interactive/**docs/** >>>>>> spreadsheets#Google_**Spreadshee**ts_as_a_Data_Source<https://developers.google.com/chart/interactive/docs/spreadsheets#Google_Spreadsheets_as_a_Data_Source> >>>>>> >>>>>> 2) You can replace LineChart with ImageLineChart in the example I >>>>>> gave you, but it is not a 1:1 replacement. It does not support the >>>>>> "useFirstColumnAsDomain" option, so it will attempt to plot RPM as >>>>>> another >>>>>> series. >>>>>> >>>>>> >>>>>> Thomas Rybka | Software Engineer | [email protected] |**** Google >>>>>> >>>>>> Thomas Rybka | Software Engineer | [email protected] |**** GViz >>>>>> >>>>>> >>>>>> On Fri, Mar 22, 2013 at 5:51 AM, SJO <[email protected]> wrote: >>>>>> >>>>>>> Hi all >>>>>>> >>>>>>> Just started to take a look at the Google Charts API. I have a >>>>>>> couple of problems, if someone could clarify/solve please :- >>>>>>> >>>>>>> I've got some simple data in a google spreadsheet ( >>>>>>> https://docs.google.com/a/di.****cx/spreadsheet/ccc?key=**0Aq5ZGf** >>>>>>> oqCa6gdHZYelhoXzNIMkN0M**WtiYkYy**M0ZhQWc#gid=0<https://docs.google.com/a/di.cx/spreadsheet/ccc?key=0Aq5ZGfoqCa6gdHZYelhoXzNIMkN0MWtiYkYyM0ZhQWc#gid=0> >>>>>>> ). >>>>>>> >>>>>>> Column B is what I want for my X axis. >>>>>>> Columns C+ are the series data. >>>>>>> >>>>>>> 1) I've got some sample code on the playground rendering this data >>>>>>> in a LineChart object. Works fine, however I can't figure out how >>>>>>> to show the X axis (RPM). I notice from the normal LineChart example, >>>>>>> where you use an array in the script, the first column (0) is used for >>>>>>> the >>>>>>> X axis. Could someone please confirm if the Data Source Request method >>>>>>> of >>>>>>> populating a LineChart object differs? If I specify column B (RPM) >>>>>>> in my query, it just shows it as series data and not the X axis. >>>>>>> >>>>>>> 2) Should I be able to directly replace LineChart with an Image >>>>>>> LineChart object? I appreciate the latter is not an official Google >>>>>>> chart type. If I simple substitute the object by name I get nothing in >>>>>>> the >>>>>>> output. I do not know either if ImageLineChart is compatible with a >>>>>>> Data >>>>>>> Source Request? >>>>>>> >>>>>>> >>>>>>> If anyone could please clarify/demonstrate the above, that'd be >>>>>>> fantastic. >>>>>>> >>>>>>> >>>>>>> Many thanks in advance :-) >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> >>>>>>> >>>>>> >>>>>> -- >>>>> >>>>> >>>>> >>>> >>>> -- >>> 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?hl=en. >>> For more options, visit https://groups.google.com/groups/opt_out. >>> >>> >>> >> >> -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
