Google Charts requires all data to be a sequence of rows where the cells in one column all have the same type. Your data appears to be a transpose of that, where you want the first row to be years, the second row to be amounts.
You could either transpose your data in your spreadsheet first, or perhaps the pivot operation in Query will do what you want: https://developers.google.com/chart/interactive/docs/querylanguage#pivot On Thu, Jun 9, 2016 at 9:41 AM, Igor Banaszuk <[email protected]> wrote: > And this is the JSON.txt file > > /*O_o*/ > google.visualization.Query.setResponse({"version":"0.6","reqId":"0","status":"ok","sig":"346981663","table":{"cols":[{"id":"A","label":"Year","type":"string"},{"id":"B","label":"2011","type":"number","pattern":"\u0022$\u0022#,##0"},{"id":"C","label":"2012","type":"number","pattern":"\u0022$\u0022#,##0"},{"id":"D","label":"2013","type":"number","pattern":"\u0022$\u0022#,##0"},{"id":"E","label":"2014","type":"number","pattern":"\u0022$\u0022#,##0"},{"id":"F","label":"2015","type":"number","pattern":"\u0022$\u0022#,##0"}],"rows":[{"c":[{"v":"Total > Assets"},{"v":16000.0,"f":"$16,000"},{"v":54000.0,"f":"$54,000"},{"v":200000.0,"f":"$200,000"},{"v":500000.0,"f":"$500,000"},{"v":650000.0,"f":"$650,000"}]}]}}); > > On Wed, Jun 8, 2016 at 9:13 PM, Igor Banaszuk <[email protected]> > wrote: > >> Here's a screenshot of the spreadsheet. >> >> On Wed, Jun 8, 2016 at 4:15 PM, 'Daniel LaLiberte' via Google >> Visualization API <[email protected]> wrote: >> >>> We won't be able to tell from your code that does the fetching. All >>> depends on what's in your spreadsheet. Could you point us at that? I >>> don't want to type in the googlygoop url. Thanks. >>> >>> On Wed, Jun 8, 2016 at 3:59 PM, <[email protected]> wrote: >>> >>>> >>>> https://developers.google.com/chart/interactive/docs/spreadsheets#embedding-achart-in-a-spreadsheet >>>> >>>> Hey guys, I checked my JSON file and no errors show up and I can't seem >>>> to find an error in my code, but my chart isn't showing up. >>>> >>>> Does anyone have a clue as to why it's not showing up? >>>> >>>> -- >>>> 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/c8312698-14ab-4a23-be1a-215fc6cfcfb9%40googlegroups.com >>>> <https://groups.google.com/d/msgid/google-visualization-api/c8312698-14ab-4a23-be1a-215fc6cfcfb9%40googlegroups.com?utm_medium=email&utm_source=footer> >>>> . >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> >>> >>> -- >>> Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> >>> [email protected] <[email protected]> 5CC, Cambridge MA >>> >>> -- >>> You received this message because you are subscribed to a topic in the >>> Google Groups "Google Visualization API" group. >>> To unsubscribe from this topic, visit >>> https://groups.google.com/d/topic/google-visualization-api/yng8AR-BJ9A/unsubscribe >>> . >>> To unsubscribe from this group and all its topics, 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/CAOtcSJN-z%2BCRVpm9jaonRg_NnwYTAgj%2Byde5kOgnMejguNjGbQ%40mail.gmail.com >>> <https://groups.google.com/d/msgid/google-visualization-api/CAOtcSJN-z%2BCRVpm9jaonRg_NnwYTAgj%2Byde5kOgnMejguNjGbQ%40mail.gmail.com?utm_medium=email&utm_source=footer> >>> . >>> >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> > -- > 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/CALs6n%2B2w-gVamDYkCq01D%2BK33faqro36DHmWsOPoRLAcpZdmDg%40mail.gmail.com > <https://groups.google.com/d/msgid/google-visualization-api/CALs6n%2B2w-gVamDYkCq01D%2BK33faqro36DHmWsOPoRLAcpZdmDg%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > > For more options, visit https://groups.google.com/d/optout. > -- Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> [email protected] <[email protected]> 5CC, Cambridge MA -- 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/CAOtcSJOS79u%2BQTPgAKCNvt0%2BtOYROX7CoMWa_yR1uzzG-vA9eQ%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
