How to set conditional formatting in Pivot Chart?

[JennyApril]

I created a pivot chart which can be used to sort by Machine, Year, etc.

And I would like the values shown up with different color based on its range:
0-50 Red
50-70 Yellow
above 70 Green

I could set up conditional formatting on a simply chart by creating additional columns breaking down the three ranges and put NA() when the data is irrelevant.

BUT I have no clues how to link such column to PIVOT Chart?
Is there a better way to do that?

Thanks.

[PlusX.me]

Can you send a file ? What type of chart (Column, Line,..) are you using ?