Conditional Formatting a Bar Chart

[SLester]

Hi,

I wish to colour code my bar chart. I have a range of codes which I wish to give an individual colour when it is represented on the bar chart. E.g codes beginning with 123 = Red, codes beginning with 456 = blue and so on.

I know how to conditional format cells, but i'm unsure on how to make the colours on my graph correspond with the cell.

Does anyone have an idea how to do this by running a macro? or any other solution?

Thanks

 

[VoG]

This should help you Conditional Formatting of Excel Charts - Peltier Tech Blog