Hi John, After you fetch the data from the spreadsheet, then you can modify it, but it might be better to use a DataView to add a role column. See: https://developers.google.com/chart/interactive/docs/reference#DataView
On Fri, Jan 27, 2017 at 10:50 AM, John Martins <[email protected]> wrote: > Hi all, > > I'm embedding a simple bar chart from a Google Sheet onto a web page > <https://learn.mtholyoke.edu/mhc-forever-challenge-test>, and I'm having > trouble with styling the components. I need each bar on the Y-axis to be > one of five colors, and also some other small style adjustments that I > think I might be able to figure out if I can just sort out how the chart is > pulling in the style information. (Posting a JPG of what I'm trying to > emulate.) > > I saw in some posts that the trick is to declare roles for columns, but > the only examples are from charts that have the data coming from the JS > itself, not from an external source like Sheets. Can anyone point me in the > right direction? > > Thanks in advance for your help! > > > <https://lh3.googleusercontent.com/-iWrScour7Xg/WItsUnnq7qI/AAAAAAAA_r0/8TKZ8Qgv4Go4PqEjFuhR3vv871nqYFeuACLcB/s1600/2010_1643.png> > > -- > You received this message because you are subscribed to the Google Groups > "Google Visualization API" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to google-visualization-api@ > googlegroups.com. > Visit this group at https://groups.google.com/ > group/google-visualization-api. > To view this discussion on the web visit https://groups.google.com/d/ > msgid/google-visualization-api/4ed91465-056f-44b8-a28e- > fe30dc113969%40googlegroups.com > <https://groups.google.com/d/msgid/google-visualization-api/4ed91465-056f-44b8-a28e-fe30dc113969%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> [email protected] <[email protected]> 5CC, Cambridge MA -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/google-visualization-api. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CAOtcSJOKrUJcBFeq_3HJWkMMgz45AcFgTpaCQ5o5a8euSO2CQA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
