CF or VBA to format colour based on axis label

[halesowenmum]

Question from a complete Excel dunce so - you have been warned!

I need to do a doughnut chart for Jan through Dec and have formatted (manually) the attached (I hope the image comes through ok).

https://drive.google.com/open?id=1DYmXE7TO9sXRu6Ox68ODLeWuRa80rpW9

The doughnut in Col F (which is the data for Jan) is for the data in row 7 and I want it such that the colour for Late (regardless of the value) is always shown Red, that the colour for Not started (regardless of the value) is always Grey, that the colour for In progress (regardless of the value) is always shown Green. I've shown in cols G and H the results after following certain steps and the effect it has on the doughnuts formatting (all of which manually applied). Copy/paste for the chart works fine but when I re-direct the chart to the appropriate row of data (eg for Feb to row 8 instead of 7) all the formatting disappears and I'm back to square one.

So I'm looking for a solution which, when I copy and paste for all the charts I need, it will CF based on the labels Late, In Progress etc and even when I say ok look at row 9 for your values, that formatting remains.

I know this must be possible and have an vague idea CF and/or VBA would do it, I just don't know how to do it.

I'd be so grateful for help with this.

Many thanks indeed.

 

[halesowenmum]

Not sure that link is working so have tried again:
https://drive.google.com/file/d/1DYmXE7TO9sXRu6Ox68ODLeWuRa80rpW9/view?usp=sharing

 

[halesowenmum]

Ignore the bit about the slice changing shape - not quite sure what I did there, but it isn't actually an issue.

 

[halesowenmum]

I think for clarity it's the Category that I need to CF on.