Continuous 12 Month Chart

D

Dave Y

Hello,

I have a chart that I input data into on a monthly basis.
The chart currently goes from 8/31/2002 until 1/31/2004.
I want to only show the most recent 12 months worth of
information but I don't want to lose the data from the
previous months. In other words when I enter the data for
the month of February 2004 I want only Feb 2003 until Feb
2004 to show on the chart. So every month when I add the
latest info, the new month will be added and then what
would be the 13th month would be dropped off the chart,
but the data will still remain on the worksheet that
contains the data. If more info is needed such as
formulas that are currently being used please let me know
and I will supply whatever is needed in a reply post.
Thank you in advance for any assistance that may be
provided.

Dave
 
D

Dave Y

Hi JE,

Thanks for the link, it was helpful and has already
pointed me in the right direction.

Dave
 

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

Top