Hi Rob, You have a couple different choices.
First, on https://developers.google.com/chart/interactive/docs/spreadsheets#queryurlformat it talks about adding a range parameter to your spreadsheet url, like " *&range=A1:C4*" But since your data values are arranged across columns (D2, E2, and F2), you really need to transpose the data so the values are arranged across rows; that is, the rows and columns would be swapped. Either you can do the transpose in your spreadsheet (see the Transpose formula, https://support.google.com/docs/answer/3094262), or you have to do it in your code once you get the data in the browser, which sounds like more work if you are not familiar with JavaScript. Let me know if you want to do it in JavaScript and need help. On Wed, Oct 22, 2014 at 9:25 AM, Rob H <[email protected]> wrote: > Can anyone help with this - It's drinking me round the bend :) > > Cheers! > > -- > You received this message because you are subscribed to the Google Groups > "Google Chart 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-chart-api. > For more options, visit https://groups.google.com/d/optout. > -- Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> - 978-394-1058 [email protected] <[email protected]> 5CC, Cambridge MA [email protected] <[email protected]> 9 Juniper Ridge Road, Acton MA -- You received this message because you are subscribed to the Google Groups "Google Chart 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-chart-api. For more options, visit https://groups.google.com/d/optout.
