Shaded area under a curve 2

[gaufridus]

I am currently devising an excel spreadsheet containg a graph of the data, is there a way to shade the area above (or below) the curve in a different colour?

 

[cowski]

An area chart (under standard types) may give you what you want.

 

[Panars]

Check this webpage out for an example of how to do this.

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

 

[ERE]

I've been wanting to be able to do that for a long time! Thanks for the great link... star for Panars

 

[gaufridus]

I don't think that an area chart would suit, the problem is that my chart has two curves:
The Y axis shows positive values and negative values. The Y axis runs from -5 to +5 with the x axis starting at zero on the Y axis. X axis values run from 0 to 200. I have plotted two curves - one is a positive curve and the other a negative curve. These two curves start at 0,0 and diverge as X increases. I want to shade the areas outside the part of the chart contained by the two curves.
These two curves show the limits of acceptability for a calibration sequence that will be plotted manually on a printed version of the chart. I want to show graphically that if any (manually) plotted point is in the area outside the two curves then that value will show an unacceptable condition.

 

[joerd]

Did you read

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

?
You can obviously play with the chart area fill color and the series fill colors to get what you want.

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.

 

[HgTX]

The standard Excel area chart won't work, but check out the website that Panars posted--it shows how to fake this for an X-Y plot. The page for doing area between two curves is here:

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

It looks like it's actually easier to show the area outside the curves than the area between them.

Hg

Eng-Tips policies: faq731-376