Conditional formatting:
http://peltiertech.com/Excel/Charts/...nalChart1.html
Background effects:
http://peltiertech.com/Excel/Charts/BackgroundFill.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
"Will" wrote in message
...
If there a way to set up a line chart to show the point values that are
negative in Red while the other point values are shown in other color? -
Or
- or there a way to show the chart background color in a different color
below the 0 value on the Y axis?