Adjusting Chart source data when column is deleted

Y

YBTM

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to copy XY charts into new worksheet? 1
XY scatter plot with more than 32000 rows in Excel 2003 0
Average bar charts with individual data points 2
Embed the same Excel multiple times 0
Data points in chart incorrect 0
Copying Named Ranges in Chart Series 1
Chart Source Data 5
My chart's X-axis isn't working properly 0

Top