Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional chart
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 |
#2
|
|||
|
|||
Hi,
You can do this by adding extra data series for the various colours and formula to effect the data displayed. Jon Peltier has some instructions on how to construct conditional charts. http://peltiertech.com/Excel/Charts/...nalChart1.html Cheers Andy Graeme Bowser wrote: 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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Road map with Chart Conditional Formating | Charts and Charting in Excel | |||
Activating a Chart object | Charts and Charting in Excel | |||
Conditional formatting in a chart | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) |