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.
Sample data:
| Country | Actual | Target |
APAC | 138 | 130 |
| China | 33 | 30 |
| Japan | 19 | 20 |
| India/SA | 11 | 10 |
| ANZ | 13 | 10 |
| Korea | 18 | 20 |
| SEA | 19 | 20 |
| TW | 25 | 20 |
Clustered Column Chart:
Would like to have Actual that are more than the corresponding Target to be in green and red when lower than the corresponding Target, i.e. columns of APAC, China, TW & ANZ to remain green and the columns of Japan, SEA and Korea to be in red.
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)?