Excel Graph: Putting in a expected-data-range window
Posted by Windowless Will on September 06, 2001 8:40 AM
I want to plot some time-based data in excel, and create a shaded window, behind the data - on the graph, that shows where my data is suppose to fall. The catch is that I want to tell it where the top and bottom is, so that if I change the scale of the chart, the window covers the same range. If I put in an auto-shape, then scale my chart, the autoshape scales as well. Is it possible to do what I want with excel?
Thanks
Posted by Mark W. on September 06, 2001 9:48 AM
Will, use an Area-Line combination chart, and make
the lower limit the lower of the 2 area series.
Make the area pattern for the "lower" series the
same color as the plot area (background) color.
For example, suppose that cells A1:D5 contain...
{"Date","Value","Upper Limit","Lower Limit"
;36892,10,25,5
;36923,20,25,5
;36951,30,25,5}
...the following series should do the trick...
=SERIES(Sheet1!$B$1,Sheet1!$A$2:$A$4,Sheet1!$B$2:$B$4,1)
=SERIES(,Sheet1!$A$2:$A$4,Sheet1!$D$2:$D$4,2)
=SERIES(,Sheet1!$A$2:$A$4,Sheet1!$C$2:$C$4,3)
Series 1 should be a Line chart while series 2 & 3
are setup using the Area chart type.
Posted by Mark W. on September 06, 2001 9:56 AM
A minor typo fix and some additional comments...
...Obviously, the cell range for my sample data
should be: A1:D4
Also, using this approach it's best to turn off
gridlines and *unchecking* the x-axis scale
option for "Value (Y) axis crosses between dates".
