If the monthly update is something that will happen on a regular basis,
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

In article ,
says...
I was emailed a line chart that is per month on numbers from 1000 to 9000 and
want to update it with new monthly information. I don't work with excel
often and am at a complete loss.