How would I set up data for a monthly chart to automatically advance it's range to capture the new month's data, along with the previous 11 months, while retaining a history of all data? This is what I think of as a rolling 12-month chart.

Thank you,
Frank