That sounds like the second example:

http://peltiertech.com/Excel/Charts/...nalChart2.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"confused!!" wrote in message
...
perhaps I should restate what i anticipate the end result would be (if
$b$3=$c$3,...then the bar from the target point and up is color=red).

for example my target is 53. the actual count is 72. the column color
higher than the 53 mark will be red while the other bar remains the chosen
color.

"Ed Ferrero" wrote:

Hi,

Most methods rely on charting two series in stacked bar charts.
You use formulas in he worksheet to determine what values are charted in
each series.

e.g. =IF($B$3=$C$3,B3,NA()) will show the value in B# if the condition
is
met, or #N/A otherwise.

If you want an automated method, go to
http://www.edferrero.com/ExcelCharts...2/Default.aspx
and look for the 'Conditional Format Bar Chart' sample.

Ed Ferrero
www.edferrero.com