View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kcope8302 Kcope8302 is offline
external usenet poster
 
Posts: 44
Default Upper and Lower limit lines on scatter graph

I am doing a standard deviation graph where I have 2 cells. One of which is
the upper limit and the other is the lower limit. The actual data on the
graph is set and will not change but the upper and lower limits can be
changed and i want the chart to reflect the change.

Example:

Upper deviation: <=.05
Lower deviation: =-.05
Now if I were to change these both to 1 and -1 respectively is there a
method of the chart making that change and showing what data on the chart now
falls within this new set?