Adjusting Chart source data when column is deleted

Hi all,

I have a chart that plots data from $B$9:$BA$9$ on a
worksheet in the same workbook. This chart is a running
average so every week the first column is deleted and new
data is added to BA9. Problem is when column B9 is
deleted the chart adjusts the data source to be
$B$9:$AZ$9. What can I do to retain the reference of a
series in a chart no matter what I do to the columns in
the referenced worksheet? Or is there something I should
be doing differently in the source worksheet? There are
many worksheets and charts so going to each chart to
update the references takes a long time.

Any ideas would be very much appreciated

I have found my answer - thanks
-----Original Message-----
Hi all,

I have a chart that plots data from $B$9:$BA$9$ on a
worksheet in the same workbook. This chart is a running
average so every week the first column is deleted and
new
data is added to BA9. Problem is when column B9 is
deleted the chart adjusts the data source to be
$B$9:$AZ$9. What can I do to retain the reference of a
series in a chart no matter what I do to the columns in
the referenced worksheet? Or is there something I should
be doing differently in the source worksheet? There are
many worksheets and charts so going to each chart to
update the references takes a long time.

Any ideas would be very much appreciated
.