Color Formatting of Graph Series (via Graph Series Label)

Hi all,

Thank you in advance for any advice or solutions provided for this. I have a simple line chart of weekly period against names:

Graph.Format.Color.240615.xlsx

I would like to be able to change the series colour by changing the cell colour in which the name is placed - I have put the example and outcome needed, as excelforum dictates ;-).

A couple of extra points on this; The worksheet is a store/site/department, and will be duplicated to make another - so I would like the macro to update all charts on the active worksheet. I understand that conditional formatting is an issue, but if possible - I would like the coding to react to the conditional formatting of the names, rather than manually changing the colour - but I understand this might not be possible.

I really appreciate any help given.

J.

Hi Andy,

This is perfect. Thanks for your help!

Regards,

J