Conditional Formatting for Dot Charts

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.

 

ipekkirali_6-1646316575386.jpeg

 

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.

ipekkirali_7-1646316657438.png

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!

6
6 votes

New · Last Updated

Get Started with Idea Exchange


See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!