shaded region on a graph

[Kevin Wooding]

Hello to all

I have three data series. One representing an upper specified limit, one
representing a lower specified limit, and the third being the actual results
taken off a sample being tested. I would like to shade the area between the
upper and lower limits, and then have the line depicting the actual recorded
values placed on the chart.
This explanation makes sense to me... but I'm accustomed to being told I
live on a planet all alone... so I'll try to explain another way...
I'm have results from a sample. The acceptability of the sample is based on
whether the results fall within the specified limits. As such, I want to
graphically display
1. A line graph for the upper limit
2. A line graph for the lower limit
3. A shaded region for the acceptable area between the upper and lower
limits
4. A line graph of the actual results found


Thanks in advance for any help


/kevin

 

[harold]

-----Original Message-----
Hello to all

I have three data series. One representing an upper

specified limit, one representing a lower specified limit,
and the third being the actual results taken off a sample
being tested. I would like to shade the area between the
upper and lower limits, and then have the line depicting
the actual recorded values placed on the chart.

Sounds like you want to start with a stacked area chart
for the upper and lower limits, then format the lower data
series and remove its colour. Then add the actual results
as a line graph, (edit paste special [?] and then format
the series and change it to be plotted on the secondary
axis).

(PS Nice to know someone else has trouble explaining
things simply.)

H

 

[Jon Peltier]

Kevin -

Welcome to my planet! This page on my web site describes how to get a
vertical band on a chart. You can probably figure out how to adjust it
to make a horizontal band:

http://www.geocities.com/jonpeltier/Excel/Charts/ColoredVerticalBand.html

If not, post back with what progress you made, and where you got stuck.

- Jon