Pie chart results in blank screen, others work.

  • Resolved benhen31

    (@benhen31)


    5 years, 1 month ago

    Hi,

    When using this shortcode to display a pie hole chart I just get a blank space. This used to work fine, and the same spreadsheet used to display the data as a table works fine. Could it be that google have changed something in the API about pie charts that the plugin needs updating?

    Here’s the shortcode I’m using:
    [gdoc key=”https://docs.google.com/spreadsheets/d/1Dj_J8XMKQrXR6Ab70BSetU2ipaVzUCEuGdSVht16IOk/edit#gid=1874736661″ chart=”Pie” chart_pie_hole=”0.4″ chart_pie_slice_text=”value” title=”Total Mathletics Points Per Year Group” style=”min-height:600px;border:none;” chart_background_color=”#f7f7f7″ chart_colors=”#2bafdb #27c4b9 #2ee897 #24b766 #1d8191 #2577ba”]

    And here’s the page where you can see other working charts, and the blank space under the ‘mathletics’ heading where the pie chart should be:
    https://huntingdonprimary.cambs.sch.uk/data-breakdown/

    I don’t think I’m doing anything wrong, although I might be. Everything was working fine a few weeks ago and now isn’t – I haven’t changed anything on my end.

    Thanks,
    Ben.

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
  • Plugin Author Meitar

    (@meitar)

    5 years, 1 month ago

    Your Spreadsheet data format is not compatible for Pie charts. You should (re-)read the relevant documentation. First of all, either remove the header row (“Year” and “Total Poins“), or use query="OFFSET 1" in your shortcode. Secondly, be doubly-sure your columns are using the correct data format; strings in column 0 (“A“), and numbers in column 1 (“B“), by selecting Format -> Number -> Number in the menu bar.

Viewing 1 replies (of 1 total)
  • The topic ‘Pie chart results in blank screen, others work.’ is closed to new replies.