Horizontal multi data 12 month rolling chart, multiple sheets.

**allstar51788** · 08-13-2012, 08:52 AM

I have been looking for a while now on how to modify and existing excel sheet for work. I have 8 sheets: 4 with data and 4 with the corresponding charts for that data. I would like the charts to automaticallly update and only keep the last 12 months of data. There is data on here that goes back to 2009. Moreover instead of listing the dates vertically they were listed horizontally with multiple rows of data beneath them also expanding horizontally. I have attached the excel file and deleted any personal data and senstivie info. I have been trying to use the offset function but with no success. Can someone please help?

**allstar51788** · 08-13-2012, 01:21 PM

anyone? Any help would be greatly appreciated?

**Ace_XL** · 08-13-2012, 02:00 PM

This thread will help you get started with dynamic charts. Make note of the defined name ranges that are used.

http://www.excelforum.com/excel-char...el-2003-a.html

**allstar51788** · 08-15-2012, 09:49 AM

Thanks but this isnt a basic dynamic chart its a little more out there. I know how the dynamic charts work but i cant seem to go the couple steps further mine requires without errors.

**allstar51788** · 08-16-2012, 04:20 PM

Can anyone help?

**allstar51788** · 08-20-2012, 02:06 PM

Has anyone tried something like this before?

**allstar51788** · 08-29-2012, 08:53 AM

Ok. So I figured out how to make the graph auto update with the dates moving horizontally instead of vertically and attempted a 12 month rolling fix. Except the graph works perfectly when you auto update but keeps all the data instead of the most recent 12 months. Thoughts?