You could make two series, one for positive points, one for negative.
It's actually less complicated than the example on this web page:
http://peltiertech.com/Excel/Charts/...nalChart1.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
Carol wrote:
How do I print a point on a graph in different colors based on whether the
point value is negative or positive?
Thanks,
Carol