Forum Discussion
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 >= Target and red if Actual < Target.
X Axis - Country
Y Axis - Actual
Y Axis - Target
However, I am unable to find the "fx" button under Columns to apply the conditional formatting. I am currently using the April 2022 version. Is there another way to apply the conditional formatting?
see attached. I cheated by separating the scenarios into different columns Then I cheated again by arranging the value fields in a certain order.
6 Replies
You may need separate Actual series. Please provide sanitized sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.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.
