Showing significance as an asterisk in column charts

8 views

Skip to first unread message

Jan Nylen

unread,

Jun 22, 2017, 1:22:45 PM6/22/17

to Google Visualization API

Hi!

I couldn't find any similar topic when I searched for significance, but I was wondering whether anyone knows of some easy way to programmatically draw an asterix on a bar in a grouped barchart when a certain data cell is significant or not.

Say you have two 10x10 matrices that you take in from google sheets and in one datatable, lets call it the 'value table', you have values that correspond to the value of each bar in a grouped barchart and in the other table you have a table with the corresponding significance value for those. So for all cells/bars with a corresponding significance value > 0.95 in the significance matrix I want to have an asterix showing in the barchart.

I was thinking about using the 'annotation' option and adding an asterix as an annotation in the 'value matrix' for all cells that have a correpsponding significance <0.95. I haven't solved it programtically though since my understanding of how to access datatables generated from google sheets is a bit limited. Any tips on a better solution or tips on how to solve the proposed one is welcome!