Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Value Plus ( or Minus) Upper (or Lower) Limit | Excel Worksheet Functions | |||
create SPC chart with 3 sigma Upper/Lower control limit | Charts and Charting in Excel | |||
Change from mixed caps and upper lower to all upper lower case | Excel Worksheet Functions | |||
Count occurence with user defined upper&lower limit. | Excel Worksheet Functions | |||
Limit lines in XY scatter chart | Charts and Charting in Excel |