How can i change chart data point format based on value?

[Harold96]

I have a simple column chart with a single data series. I would like to
change the color of an individual data point column depending on value.

Thanks very much.

 

[Jon Peltier]

You want to make a conditional chart:

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

- Jon

 

[Harold96]

Thank you, Jon:

As soon as I saw the examples, the rest clicked in...

Thanks again!

 

[Jon Peltier]

My favorite people only need a small hint!

- Jon