Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Control Charts: "Floating Maximum"
Obviously, ignore my last post. Sorry about that.
I've been asked to have a look at a control chart system that I'm fairly familiar with. Now, though, the request is to somehow limit the data displayed, so that "outlying data" isn't plotted. Normally, I could just define a maximum of 1, but that doesn't help in cases the upper and control limits are only seperated by 1%. These charts are currently designed to be very dynamic as control limits can vary widely in this system. Is there a way I could possibly assign a formula to the maximum value of a chart? For example, set the maximum to 125% of the upper control limit (which in itself is dynamic as well)? -- Burnnie Holliday Data Wrangler |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Control Charts: "Floating Maximum"
You need to use VBA to make the limits dynamic:
Link Chart Axis Scale Parameters to Values in Cells http://peltiertech.com/Excel/Charts/...nkToSheet.html - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Burnnie Holliday wrote: Obviously, ignore my last post. Sorry about that. I've been asked to have a look at a control chart system that I'm fairly familiar with. Now, though, the request is to somehow limit the data displayed, so that "outlying data" isn't plotted. Normally, I could just define a maximum of 1, but that doesn't help in cases the upper and control limits are only seperated by 1%. These charts are currently designed to be very dynamic as control limits can vary widely in this system. Is there a way I could possibly assign a formula to the maximum value of a chart? For example, set the maximum to 125% of the upper control limit (which in itself is dynamic as well)? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Control Charts: "Floating Maximum" | Charts and Charting in Excel | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
how can i save "floating cells" in an excel document?? | New Users to Excel | |||
"Control" plus "click" doesn't allow me to select multiple cells | New Users to Excel | |||
Scroll Bar missing "Control" tab in "Format Properties" dialog box | Excel Discussion (Misc queries) |