Make a line in a bar chart, and change color of any bars that exceed the line

[MarkM]

I need to make a bar chart that contains a line, and any bar in this
chart that exceeds this line will change color, say from green to red.

For instance, if I had a population bar chart, and any city whose
population exceeded the line drawn at 1,000 would cause their bar to
change from green to red.

If anyone can help, it would be greatly appreciated.

Thanks,
Mark

 

[Debra Dalgleish]

Andy Pope has instructions for a conditional line chart:

http://www.andypope.info/charts/conditionalline.htm

 

[Andy Pope]

Hi,

I think Jon's page is move appropriate as the OP wants the bars to
change colour rather than the goal line.
http://peltiertech.com/Excel/Charts/ConditionalChart1.html

Cheers
Andy

 

[Debra Dalgleish]

Thanks Andy -- I misread it as a "line chart"

Hi,

I think Jon's page is move appropriate as the OP wants the bars to
change colour rather than the goal line.
http://peltiertech.com/Excel/Charts/ConditionalChart1.html

Cheers
Andy

 

[MarkM]

Thanks to all who replied. Jon's page worked out great.

Mark