Is it possible to change the colour of a chart base on the dropdown list?

[ambepat]

Hey Excel Gurus,

I am trying to change the colour of a chart base on a drop-down list which are Expired, Due in 7 Days and Due by 30 July 2018.

What I want is when I click on the expired drop-list, I want my bar chart colour to change to red, Due in 7 Days will change to amber and Due by 30 July the colour will change to Green.

I have look everywhere for an answer but I can't see to find a clear-cut solution.

Any help will be greatly appreciated.

Thanks,

P