| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
high-low lines
I need to draw a line between the expected UCL and LCL for each set of values
on a comparison chart. Using the existing "high-low" line function, it draws a line between the highest value and the lowest value. I may, for example, have an actual value higher than the Upper Control Limit and it should not be included in the line. Can anyone help me? Thanks. |
|
#2
|
|||
|
|||
|
high-low lines
You could plot a point at the LCL (hide the point: format it with no
line and no marker) and add a Y Error Bar with the value UCL - LCL. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Lynne wrote: I need to draw a line between the expected UCL and LCL for each set of values on a comparison chart. Using the existing "high-low" line function, it draws a line between the highest value and the lowest value. I may, for example, have an actual value higher than the Upper Control Limit and it should not be included in the line. Can anyone help me? Thanks. |
|
#3
|
|||
|
|||
|
high-low lines
Jon - thank you. You're a lifesaver!
"Jon Peltier" wrote: You could plot a point at the LCL (hide the point: format it with no line and no marker) and add a Y Error Bar with the value UCL - LCL. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Lynne wrote: I need to draw a line between the expected UCL and LCL for each set of values on a comparison chart. Using the existing "high-low" line function, it draws a line between the highest value and the lowest value. I may, for example, have an actual value higher than the Upper Control Limit and it should not be included in the line. Can anyone help me? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lines separating rows and columns won't unhide | Excel Discussion (Misc queries) | |||
| Partial Grid Lines | Excel Discussion (Misc queries) | |||
| Column lines | New Users to Excel | |||
| Missing lines in chart w/x-axis with months 1-24... | Charts and Charting in Excel | |||
| Add more lines and more columns in Excel | Excel Worksheet Functions | |||
Linear Mode
