Hi Jolene,
Your syntax is a bit wrong. You need a comma after the chartType property,
and you need to close your quotes for the string 'Testing'. Additionally,
you're not loading a package, so your first line should be more something
like this: google.load('visualization', '1.1', {'packages': ['table']});
You're also not loading jsapi from Google. You need to add the full url in
the external resources, otherwise it tries to load jsapi from jsfiddle.net.
Try putting in the full https://www.google.com/jsapi?dummy=.js instead.
Here's the fiddle with all the errors fixed: http://jsfiddle.net/597Yj/17/
While the data loads fine, it looks like there's still an error with your
query. There are no columns in your sheet named "AL", "AM", or "AN". You'll
need to change the query to select columns that exist that you'd like to
display. Here's an example where it selects columns E, F, and G:
http://jsfiddle.net/597Yj/19/.
-Mitch
On Fri, Jan 3, 2014 at 11:44 AM, Jolene Oropilla
<[email protected]>wrote:
> I have experience with Google Charts API but transitioned to educating
> myself and experimenting with the Visualization API in order to have more
> control of formatting and such.
>
> My first project:
>
> - Use the Chartwrapper class to draw a simple table chart
> - The datasource is a specific sheet within a Google Sheet workbook
> (or whatever calls their equivalent to an Excel workbook)
> - There is a query to specific columns
>
>
> My problem:
>
> - Even with a simple set up, I'm still not able to get anything to
> appear in the Results pane
>
>
> Things I've tried:
>
> - Checked my syntax
> - Confirmed my Google Sheet was public and editable (This was a
> suggestion from a co-worker, but I did not need to change permissions with
> the Charts API. Can someone confirm that I do need to have a public,
> editable (or even publish) version of my Sheet? This would be an issue
> since I'll be working mostly with work-related documents that will need to
> stay private.)
> - Stared at the screen for way too long...
>
>
> Resources:
>
> - jsfiddle: http://jsfiddle.net/joropilla/597Yj/12/
>
>
> Looking forward to hearing from the community. Any help is already much
> appreciated.
>
> --
> 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.
> 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.
For more options, visit https://groups.google.com/groups/opt_out.
