Forum Discussion
bdehning
Post Prodigy
Post ProdigyAutomating Column colors for each year
I currently use Clustered Column Chart to show data by a field called Inception Year. I select and set the colors for eacy year by Formating Columns and applying Series settings for each year and se...
Thejeswar
Super User
Super UserHi bdehning ,
In case our clustered column chart does not use a legend to split the data then you can use a calculated column to apply conditional formatting to the fields. That way every January will have a certain color, February will have a certain color and so on.
It is a limitation that you can use conditional formatting when there is a legend in use in the visual
Regards,