Charts not displaying

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author Meitar

    (@meitar)

    11 years ago

    Your data contains no fields identifiers, only data. That’s not going to work because it’s unclear what the fields are.

    Edit your spreadsheet to include column headers. For the sheets you’re showing, sensible column headings probably sound like “Category” for the string column (the one with “Staff,” “Student Stipends,” etc. in it) and “Amount” for the integer column.

    Thread Starter pvdstudentunion

    (@pvdstudentunion)

    11 years ago

    Thanks for the quick reply, I’ve added column headers but still having no success in displaying tables as a pie, bar, or any other kind of chart. Actually, now if I include the chart attribute, the whole thing disappears. Here’s what Inspect Element says:

    Refused to execute script from ‘https://docs.google.com/spreadsheets/d/1JVhqu9r7qpEtg-d830sstGlhzJbgiXApP3CEFC3RubY/export?format=csv&chart=true&tqx=reqId%3A0’ because its MIME type (‘text/csv’) is not executable, and strict MIME type checking is enabled.

    Shortcode:

    [gdoc key=”https://docs.google.com/spreadsheets/d/1JVhqu9r7qpEtg-d830sstGlhzJbgiXApP3CEFC3RubY/edit#gid=0″ chart=”pie”]

    Plugin Author Meitar

    (@meitar)

    11 years ago

    I apologize, it appears that there was also a bug in the plugin that prevented charts from displaying in the event that a query was not used, a key pointing to a Google Spreadsheet was used, and the chart attribute was included. This specific combination resulted in a bad URL being built to construct your GViz query.

    I’ve just patched the issue and rolled it into the next update to the plugin, released today. After editing your spreadsheet to include the column headings, please also update to version 0.9.9 of the plugin and let me know if that resolves the issue for you.

    Thanks for pointing me to the direction of this bug!

    Thread Starter pvdstudentunion

    (@pvdstudentunion)

    11 years ago

    Thanks. I’ve done the update, but no success, and Inspect Element still says:

    Refused to execute script from ‘http://docs.google.com/spreadsheets/d/1JVhqu9r7qpEtg-d830sstGlhzJbgiXApP3CEFC3RubY/export?format=csv&chart=true&tqx=reqId%3A0’ because its MIME type (‘text/csv’) is not executable, and strict MIME type checking is enabled.

    Super great if this can be figured out! I want this to work so badly!

    Plugin Author Meitar

    (@meitar)

    11 years ago

    You might need to ensure you’re not hitting a cache. Clear them? The shortcode you wrote out works for me when I use it, now.

    Thread Starter pvdstudentunion

    (@pvdstudentunion)

    11 years ago

    I thought I had installed the plugin, but perhaps not. Did so again and it works perfectly.

    Thank you so much for your responsiveness, this is an important function for my organization! Will be sending a donation.

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘Charts not displaying’ is closed to new replies.