View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Shane Devenshire Shane Devenshire is offline
external usenet poster
 
Posts: 857
Default Fill Positive and Negative Areas under a Scatter Plot Different Co

Hi,

I think you[re going to have problems with this one. I don't think you can
do this on a scatter chart in Excel. You can fake it with an area chart but
there are a number of problems with that approach, not the least of which is
it is not an XY scatter.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


" wrote:

I have a scatter plot connected by lines. I want to be able to fill the
positive area between the line and 0 green and the negative area between the
line and 0 red. Any ideas on how this would be possible? I looked at Jon
Peltier's website but that only allows for one type of shading.

Thanks

Adam Bush