cvrd_environment
Forum Replies Created
-
Forum: Plugins
In reply to: [Inline Google Spreadsheet Viewer] Values not aligning with date axisThanks Meitar. Must have been something going on with the Google API, as the graphs are all back to normal today.
Forum: Plugins
In reply to: [Inline Google Spreadsheet Viewer] vAxesWow, that’s great! Thanks so much for the update – that’s exactly what I needed.
Forum: Plugins
In reply to: [Inline Google Spreadsheet Viewer] chart annotationsI haven’t actually asked in the Google forums as I wasn’t sure what to ask. The annotations work fine in the chart within my Google spreadsheet – I simply select the range of columns including the column with the data and the adjacent column with the annotations, and the annotations show up as they should. It is only when I tried to include the same range in my wordpress site, that I get the error about all series needing to be the same data type.
I’ve managed a work-around of using a combo chart which accomplishes what I was trying to do (e.g., create an area chart with markers to identify specific points along the curve). Column A is the date, which is my X-axis. I put the data (volume of water used) in Column B, with the series_type set to area. Then for each annotation (I only had a couple) I add another column using my annotation text as the title of the series, and the series_type set to bar. The only value in the series is for the date where I want the annotation, and has a value set to the maximum value in the graph. The result is a vertical line at the correct location on my graph, and a corresponding legend entry containing my annotation.
This doesn’t answer my original question of how to include annotations, but it actually works better for my purposes than the annotation.