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 > > 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/ (I also fixed the URL to > use a hopefully more readable copy of your spreadsheet). > > > > > Thomas Rybka | Software Engineer | [email protected] <javascript:> | > Google > > Thomas Rybka | Software Engineer | [email protected] <javascript:> | GViz > > > On Mon, Mar 25, 2013 at 4:59 AM, SJO <[email protected] <javascript:>> 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_**Spreadsheets_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=** >>>> 0Aq5ZGfoqCa6gdHZYelhoXzNIMkN0M**WtiYkYyM0ZhQWc#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.
