View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
joecrabtree joecrabtree is offline
external usenet poster
 
Posts: 111
Default 8 Consecutive points rising or falling

To all,

I have created a dynamic Statistical process control chart, and now
wish to do the following ( If possible ):

1) Highlight in red any 8 consectutive points that are rising or 8
consecutive points that are falling.
2) Highlight in blue 8 consecutive points on the same side of the mean.
( Above or below ).

Thanks in advance for any advice/help.

Joseph Crabtree