Dynamic update for graph data

[Guest]

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.

 

[Guest]

Hi JRJ,

Use a dynamic range, have a look at
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=518

 

[Guest]

Perfect. Thanks for the help!

Hi JRJ,

Use a dynamic range, have a look at
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=518