If you're using Excel 2003, select the data and convert it to a list, and
base the chart on data in the list. Then copy this whole sheet, chart and
list and all. Replace the data in the sheet with the new data, and resize
the list to contain the data. The chart will update as the list changes
size. In Excel 2007 the approach is similar, except the list is now called a
table.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"materials scientist" wrote
in message ...
I have multiple columns of data, which are all the same length, and
correspond to a specific act. This data is charted and gives multiple
graphical anlyses. Currently, I copy the entire worksheet and paste to
another tab in the same workbook when I have another set of data to chart
from a different act. The data always starts in the same cells but the
length always varies, sometimes more and sometimes less. Can I define the
source data range as "start cell : end+down" so I don't have to redefine
every time?