MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Make chart roll

Posted by steve on June 07, 2001 2:48 PM

Could someone tell me how to keep 16 months on a line graph. What i have is multiple months on the x-axis and i keep adding months, but i need to have the graph automatically keep the most current 16 months. How would this be done?

Posted by Russell on June 07, 2001 3:19 PM

Basically you would move the source data range over one each month. You could attach it to a button that would move your range over one. Tell you what: record a macro in which you change your source data and take a look at it. If you have more questions about the specifics, post some of the code and I'll (or somebody) help you further. I've done stuff like this several times - it's relatively simple.

Hope this helps,


Posted by Mark W. on June 07, 2001 3:24 PM

You could create a dynamic range based on the
current month.