Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Control Charts: "Floating Maximum"

2 views
Skip to first unread message

Burnnie Holliday

unread,
Nov 24, 2009, 5:26:01 PM11/24/09
to

--
Burnnie Holliday
Data Wrangler

Burnnie Holliday

unread,
Nov 24, 2009, 5:33:03 PM11/24/09
to
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)?

Jon Peltier

unread,
Nov 28, 2009, 1:31:18 PM11/28/09
to
You need to use VBA to make the limits dynamic:

Link Chart Axis Scale Parameters to Values in Cells
http://peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/

0 new messages