In article ,
says...
I've looked at some examples but found myself lost. I have a sheet that
shows overtime by department (those being the rows) by month (columns), and
wanted to make a chart that will show a rolling three months for each
department, so it would show August, July, and June, and next month Sept,
Aug, July. I know I have to use the Name function and Offset in some terms
but am somewhat lost. The department names start in A7 and go down, the
months start B4 and go across. Any help would be appreciated.

For some examples see
Dynamic Charts
http://www.tushar-mehta.com/excel/ne...rts/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions