Take a look at Tushar Mehta's excellent site which has lots of info on
dynamic charts (among other things). His is based on the new data being
added to a new row but it shouldn't be too hard to change the offset()
terms to make it work for additional columns.
http://www.tushar-mehta.com/excel/ne...rts/index.html
--
Alex Delamain
------------------------------------------------------------------------
Alex Delamain's Profile:
http://www.excelforum.com/member.php...o&userid=11273
View this thread:
http://www.excelforum.com/showthread...hreadid=400718