Conditional format a PivotChart

[dave_the_bear]

Hi everyone, I have searched the internet for hours and still havent found an answer to my problem.

I have a PivotChart that is fed information from a table.

I want the PivotChart (Its a bar chart) to change the background of a series value under certain conditions.

If a bar series value is >= 80% the colour of the bar should be green

If a bar series value is <80% the colour of the bar should be red.

Is this possible in VBA?

I've attached an example of how I want it to look. This was done manually.

 

[dave_the_bear]

I'll presume no reply means it isn't possible?