Conditional Formatting 2003
 

I need the bar colors to change after reaching ONE particular point.

how do i do that? I have searched the many different posts or threads, they
all seem to be relative to more than one point or sectioned off by tiers of
breaking points.

Even the simple condition format from the peltier is based on two points. I
need a forumla that looks like (if $b$3=$c$3,...then the color=red).

Conditional Formatting 2003
 

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

Conditional Formatting 2003
 

Thank you for the direction.

I need to know how to change this information so that it is specific to my
needs. I was unable to do this when I downloaded the spreadsheet before
sending my message. So I was unsure if this was the best one to use, but you
confirm otherwise.

It did seem like the closest though.

"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

Conditional Formatting 2003
 

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

Conditional Formatting 2003
 

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