Forum Discussion
Solved
Conditional Formatting in Clustered Column Chart
Hi All, I am using Cluster Column Chart to compare Actual vs Target in Revenue and would like to apply conditional formatting to the "Actual" columns such that it will be green if Actual >= Targe...
see attached. I cheated by separating the scenarios into different columns Then I cheated again by arranging the value fields in a certain order.
Like this?
Yes, this will work. May I know how did you achieve this as i am wondering whether it will be feasible for a huge data set (without doing much manual adjustment to the data set, or none at all if possible)?