VBA code to change color of bar chart

I am having a difficult time trying to change the color of the bar graph based off the status that chosen. I've been looking at blogs and found that this can possibly be done with a vba code but I am stuck on how to do so. Is there a way a vba code can be created to have the color of the bar change if the status is changed? I have attached an example of the workbook that I am working with.