Conditional Formatting a Bar Chart

SLester

New Member
Joined
Feb 11, 2015
Messages
1
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
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Watch MrExcel Video

Forum statistics

Threads
1,099,093
Messages
5,466,594
Members
406,491
Latest member
amirkhosravi

This Week's Hot Topics

Top