Conditional Formatting for Dot Charts

Options
ipekkirali
ipekkirali Member, ALL USERS, GroupMember, Partner, Certified Model Builder Posts: 5 Frequent Contributor
in User Experience

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!

Tagged:

Categories