Conditional Formatting for Dot Charts

ipekkirali

Hi,

When putting together a dot chart utilizing a list rather than fixed number of line items in rows to populate the dots results in random colors for each dot.

 

 

For example, when there are 5+ list items per column, and that number goes up and down based on each selection, having a rainbow of colors for each chart does not work. The maintenance required to potentially adjust the colors for EVERY selection is not realistic, and simply not possible.

It would be amazing to be able to utilize conditional formatting to determine the color of each dot. It will definitely take this chart to a next level and offer a lot more flexibility.

 

Thanks!