Rolling Chart?

[Mark Buckelew]

Aybody know how to format a chart so that, as a line of
data is input, it will show the last n lines?

I've constructed an SPC chart and would like it to show
the last 50 points.

Thanks.

 

[Gord Dibben]

Mark

Check out Tushar Mehta's site for instructions and examples on this subject.

http://www.tushar-mehta.com/

Click "Dynamic Charts" under Tutorials section.

Gord Dibben Excel MVP - XL97 SR2 & XL2002