Auto increment chart range montly

I have a number of situations where I add a row of data each month and then
have to change all the series definitions of all the related charts. Is there
an easy way to automate this?

Hi,

You can used named ranges to auto expand chart data.
http://peltiertech.com/Excel/Charts/Dynamics.html

Cheers
Andy

comfuted wrote:
> I have a number of situations where I add a row of data each month and then
> have to change all the series definitions of all the related charts. Is there
> an easy way to automate this?

--

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