Link to home
Start Free TrialLog in
Avatar of Doug Van
Doug VanFlag for Canada

asked on

Google Sheets - Changing colors of charts to accommodate color-blindness?

Hello all,

After putting a lot of work into visualization of a large amount of data... more than 20 dynamic line and pie charts, I just learned today that:

a) I need to make the charts color-blind friendly (happy to do so to accommodate my viewers). 

b) Google Sheets doesn't offer any provisions for automatic color rendering for color-blind users. :( 


Is there an easy way to change the color of my charts WITHOUT having to manually edit each of the charts?


Thank you

ASKER CERTIFIED SOLUTION
Avatar of John Korchok
John Korchok
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Doug Van

ASKER

Thank you so much John. That link was really helpful.

I have a working script, but now I want to offer a few buttons on the page that one can press to assign a different color palette to accommodate for different types of seeing.

The problem is that I can't seem to assign more than one button to a script. After creating my button (via Insert Drawing), then assigning the button to a script, the first buttons assignment is lost.

I asked a new question.
 https://www.experts-exchange.com/questions/29240494/Google-Sheets-Google-script-to-select-one-of-four-different-functions.html
Thank you