You should be able to fix the hAxis to a range of 0-500 by using the
hAxis.minValue and hAxis.maxValue options (eg, hAxis: {minValue: 0,
maxValue: 500}). Getting vertical lines on the bar chart is a tricky
proposition, as there is no support for anything beyond the gridlines.
Gridline positions are auto-calculated, though, and all must be the same
color, so I doubt they will serve for your purposes. If you were referring
to vertical bars, then what you want is a ColumnChart, not a BarChart.
I've never worked with the charts within Google spreadsheets, so I'm afraid
I can't help you with the specifics involved in getting them to work right
there.
On Tuesday, March 27, 2012 2:55:47 PM UTC-4, Boulton Developer wrote:
>
> Noob here,
>
> I am 80% of the way to success. I have connected my chart to my Google
> Spreadsheet but I don't have the options in my "Gadget" to format my
> BarChart the way I need it to appear and my needs are very, very
> basic.
>
> My chart's bottom or base line is supposed to be a ruler that
> incrementally defines the "Number of Studies" or, 0 - 500, statically,
> not changing. There should be 2 vertical lines above showing the
> success of a set of studies, 1 represented by a blue line, the other
> red. In the spreadsheet the "Gadget" view displays the data the way I
> want it (except for the legend colors) with a static bottom "rule" or
> line that measures from 0-500. When I set one of my values to "200"
> and refresh the html live online I get a bottom line that is "220",
> not 500. It seems to adjust by some formula no matter what the value.
> What am I doing wrong?
>
> Better yet. I just can't seem to find the tutorial that describes in
> detail how to set up your spreadsheet to pass chart formatting info
> like "Legend" or, if it's not done that way then how?
>
> An appropriate tutorial link would be vastly, vastly appreciated.
>
> Thanks in advance!
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/google-visualization-api/-/MQ48HdkUoCwJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/google-visualization-api?hl=en.
