It seems I got myself confused. I had another look at this and I think it was the JSON methods that were described but which I didn't need.
I used the GID method of connecting to the spreadsheet - https://developers.google.com/chart/interactive/docs/spreadsheets to get the data I needed several chart types, so used options from the various types at https://developers.google.com/chart/interactive/docs/gallery Finally, I used the vanilla code from the Controls guide at https://developers.google.com/chart/interactive/docs/gallery/controls It was trying to use dataSourceUrl that was causing me problems, that and I think it needs the Google sheet published to the web which is something I didn't know. for what I want it for, the GID method of getting the data works fine. -- 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 https://groups.google.com/group/google-visualization-api. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/92b3745a-d7e0-4785-bfe6-9dc7971a3a09%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
