Seriously confused

  • Resolved dhbiz

    (@aviatedman7)


    10 years, 1 month ago

    I’ve downloaded this plugin and I know it works. But it’s not displaying the chart how I want it to from the data in my google spreadsheet. You have information on this plugin scattered all over the plugin page from Description, FAQ and Other Notes. Do you not have a pdf guide to your plugin or some single source for everything related to this plugin?? That alone would save hours of trying to understand it.
    I see you had a couple of attribute examples to use within the gdoc shortcode along with a link to a list of all available attributes. However, that link goes to googles website. Are we to assume that all the google attributes are to be placed right inside your shortcode exactly how they format it? I’m lost on how to generate a chart from data on a google spreadsheet using your plugin. I’m not really understanding what your plugin is really even useful for because on GOOGLES website, they’re giving you html code…not wordpress shortcodes.
    Where do I need to start to relearn on how to do all this?

    https://www.ads-software.com/plugins/inline-google-spreadsheet-viewer/

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

    (@meitar)

    There is not (yet) one complete guide for using this plugin to customize charts, simply because no one has asked for one before you. ?? I have plans to build a point-and-click interface to help people understand the various chart_* options, too, but that’s not ready either.

    In the mean time, if you can understand the Google API, then there isn’t actually much “new” to learn, and certainly nothing to relearn, with respect to this plugin’s shortcode options for customizing charts.

    So perhaps a better answer to your question is, what are you trying to do? If you can clearly describe your goal, maybe I can help you understand which chart options you should be using.

    For now though, to answer your question directly, you asked:

    Are we to assume that all the google attributes are to be placed right inside your shortcode exactly how they format it?

    Yes. If you want to use a given chart option described by Google in a chart from this plugin, your shortcode should include an attribute for that option similar to chart_option_as_described_by_google="VALUE-AS-DESCRIBED-BY-GOOGLE". So, for instance, if you want to use the “aggregationTarget” configuration option for Candlestick charts that Google describes here, you would use a shortcode attribute like chart_aggregation_target="auto". In such a case, your complete shortcode might look like this:

    [gdoc key="https://docs.google.com/spreadsheets/d/ABCDEFG/edit" chart="Candlestick" chart_aggregation_target="auto"]

    To reiterate, as the FAQ said:

    With a few exceptions, the name of a shortcode attribute is always an underscore_separated translation of the camelCase name of the option in the Google Chart API.

    Hope this helps. ??

    Thread Starter dhbiz

    (@aviatedman7)

    Ahh, ok. Yes, that does help a lot! Thank you much! I realize now though, I need to learn Google’s API. Never really needed it before ??

    Plugin Author Meitar

    (@meitar)

    ?? I’m glad that helps.

    To be clear, though, you only need to learn Google’s API if you want to do some serious custom configurations. I made this plugin to make it easier to add Google’s charts to our WordPress posts, so the only required attributes to add a chart is the key (which specifies the spreadsheet to use) and the chart attribute itself.

    Every other attribute is optional, so making a chart can be as simple as adding chart="Pie" to your shortcode or as complex as customizing every single available option in the Google API.

    It’s really up to you.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Seriously confused’ is closed to new replies.