Question about source data for chart

I have a worksheet that I keep track of quality control data with. I
then have charts based on the data. My problem is I only want the
charts to use the last 60 rows for the source data. So every time I add
a new row I need the source data to shift to the last 60 rows.

Take a look at this

http://www.peltiertech.com/Excel/Cha...micLast12.html


"Peter" <sleepyhouse98@yahoo.com> wrote in message
news:1126045756.902889.250200@f14g2000cwb.googlegroups.com...
> I have a worksheet that I keep track of quality control data with. I
> then have charts based on the data. My problem is I only want the
> charts to use the last 60 rows for the source data. So every time I add
> a new row I need the source data to shift to the last 60 rows.
>