It seems no one can achieve this but..

I have a spread sheet with various tick boxes, that when ticked calculate an accumulative percentage in a cell. This cell is the basis of my graph.
e.g. if the cell displays 80% - the chart with show 80% - simple.

however, I want to write a vba code that changes the fill colour of the chart depending on the percentage.

i.e. if the percentage data = 0-49% I wish the chart to display as red. 50-69% - yellow and 70%+ = green.

is this possible to achieve via simple vba?


thanks.

ive attached the sheet as example