This is a discussion on Conditional Formatting a Bar Chart within the Excel Questions forums, part of the Question Forums category; Hi, I wish to colour code my bar chart. I have a range of codes which I wish to give ...
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?
This should help you Conditional Formatting of Excel Charts - Peltier Tech Blog
Please test any code on a copy of your workbook.