View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Neg Values in Chart with Diff Color?

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?