Chart with changing colors

Guzzlr

Well-known Member
Joined
Apr 20, 2009
Messages
744
Hello All,
I'm having trouble creating a chart, which the bars change colors depending on the color created by a conditional format. In other words, if the cell B7 is green, because of conditional format, then the bar will be green. I'm thinking VBA here.
Thoughts?
Thanks
 

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Watch MrExcel Video

Forum statistics

Threads
1,095,806
Messages
5,446,572
Members
405,409
Latest member
croc23

This Week's Hot Topics

Top