Hi JRJ,

Use a dynamic range, have a look at
http://pubs.logicalexpressions.com/P...cle.asp?ID=518
--
Hope this helps,
MarkN


"JRJ" wrote:

I have a graph with data for this year and last year by month. The data for
last year by month has already been pre-populated and the data for this year
is added each month when it is available. Every month when I add the data for
this year, I have to manually expand the data range for last year so that my
year to date comparisons are kept in parity. Is there a way to update the
data range for last years data automatically when I add the data for the new
month this year?

Thank you.