I am creating a charts pro column report.
The category is a year. The value is some integre.
The color of the column should be green unless the year of the data category is the current year. In which case the column should be red.
I've tried using conditional style applied to the report element...
but that didn't seem to get "picked up" by the report.
I then put in a conditional expression in the Palette Colors field of the Chart Configuration.
The comparison and application of color works...only it applies the resulting color of the last comparison to all columns.
Any suggestions on how to conditionally color the columns of a charts pro columns chart?
Thanks in advance.
you won´t get into this without a chart customizer, hava a look for starting here:
in the chart customizer, you could define a static map to set the bar or line color to a specific value. if you need it more dynamically, read your color assignment to categories from a config file or, the better, write it into your database an read it combined with the chart data.
That´s the way I would do it.