Hello,
I have linked my google charts table to my google sheets and on my google sheet I have this: <https://lh3.googleusercontent.com/-KiyMq2jeaY0/WJB1FoRz-vI/AAAAAAAAACQ/qKOMaEk2-rYou2hH0vTnM5nPlEukxTNwACEw/s1600/Screenshot%2B%25283%2529.png> It is achieved with conditional formatting. When I display my table in google charts it changes my true and false to ticks and crosses, this means that it is recognised as boolean. <https://lh3.googleusercontent.com/-XG7xpxJNN0w/WJB2YZM21bI/AAAAAAAAACc/7iHBdMUEnBIbcTjIR_TbhsGZ1XW4lnG2gCLcB/s1600/Screenshot%2B%25284%2529.png> Is there a way I can apply a formatter to these values to match the behaviour above. I have tried this: var boolFormat = new google.visualization.ColorFormat(); boolFormat.addRange(false, "", 'black', '#ff8787'); boolFormat.addRange(true, "", 'black', '#98d381'); boolFormat.format(data, 3); But it doesn't work and I can't think of any other ways to achieve this. Any help is greatly appreciated. -- 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/dd4c8af9-750e-4614-879e-0bedb3d242c0%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
