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.