Conditional formatting in an Excel chart:

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

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


"Kim" wrote in message
...
Hi there,

I have a line chart that includes values that are above and below zero.
I've
formatted the Y axis so that the negative numbers are red, but I would
also
like the points on the line itself to be red when negative.

Can this be done?

--
-Kim