G
Guest
I have a chart that produces conditional formatting of cells (Green, amber,
red) dependant on the percentage of a target reached (number of calls taken).
The targets for red, amber & green can be varied by the user changing the
tolerance percentage in separate cells. How do I get the colours displayed
in my bar chart to reflect those of the conditional formatting in the cells
i.e. green, red or amber? Hope i've explained this simply enough
Many Thanks,
Graeme Bowser
red) dependant on the percentage of a target reached (number of calls taken).
The targets for red, amber & green can be varied by the user changing the
tolerance percentage in separate cells. How do I get the colours displayed
in my bar chart to reflect those of the conditional formatting in the cells
i.e. green, red or amber? Hope i've explained this simply enough
Many Thanks,
Graeme Bowser