Moving Dates In A Chart

[Cranford803]

I have many months of data with values for a bunch of different of outputs for the month. Column A= months {Jan, Feb, Mar,...} Column B= data1 {#,#,#,...} Column C= data2 {#,#,#,...} Column D= data3 {#,#,#,...} Column E= data4 {#,#,#,...} ETC...

I have a graph that shows only the past 12 months. Each month new data is entered and I have to manually move all the the graphed data up a month to reflect only the past year.

I am looking for a way so that when I enter in the next month's data, the graphs will automatically bump up to show only the past 12 months. What would be the best way to set this up? Thanks in advance for taking the time to lend a hand.

 

[VoG]

This should help you http://peltiertech.com/Excel/Charts/DynamicLast12.html

 

[Cranford803]

That's a fantastic reference. Thanks for the help. I will be saving that website for future use and to share with my coworkers!