Use Excel to identify changes in Trend

[sshaffer99]

I was given a spreadsheet that has over 50 control charts -- 1 control chart on each tab. The control charts are run against 1 set of data (on a tab called "data"). My job is to review every control chart every day to look for data points that are above or below control limits or that seem to have an inconsistent trend. This is very time consuming.

I wanted to make some sort of exception report that will show me inconsistent data without going through 50 control charts. One way I thought of is to do some simple conditional formating to highlight a cell that is above or below a certain value. But I was wondering if there is a way to determine if the data is on an abnormal trend over a certaing number of days. For example, if the data is "inside" of the control limit but has been trending upward and has been more thant 10% up over the last 3 days.

Does anyone have an idea on how I could accomplish this?

 

[Mindpsyche]

Just a thought: you can add another worksheet called say a Control sheet.

In this sheet you could create your formulas which would help in pointing out exceptions in your trends. Use conditional formatting to highlight high variations.

Just my 2 cents.