See Jon Peltier's example.
http://peltiertech.com/Excel/Charts/DynamicLast12.html

Cheers
Andy

Sadler wrote:
I am using the offset function to automatically update my graph, but I
need the range to only keep 12 months. Can I get the Range to find the
last populated cell and count back 12 months?
Thanks



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info