i need my chart to automatically update if i add columns. i start
everyday with 1 column and get to around 350 a day. i need to be able
to have my chart update with each addition so that i don't have to
change my chart series 350 times a day. thanks in advance for your
help.


--
caldolegare
------------------------------------------------------------------------
caldolegare's Profile: http://www.excelforum.com/member.php...o&userid=26773
View this thread: http://www.excelforum.com/showthread...hreadid=400307

I don't quite know how you add 350 columns to a worksheet, but for a
self-updating chart, see
Dynamic Charts
http://www.tushar-mehta.com/excel/ne...rts/index.html

While the examples use data in rows, the OFFSET function is easily
adapted to adding data in new columns.

--
Regards,

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

In article ,
says...

i need my chart to automatically update if i add columns. i start
everyday with 1 column and get to around 350 a day. i need to be able
to have my chart update with each addition so that i don't have to
change my chart series 350 times a day. thanks in advance for your
help.


--
caldolegare
------------------------------------------------------------------------
caldolegare's Profile: http://www.excelforum.com/member.php...o&userid=26773
View this thread: http://www.excelforum.com/showthread...hreadid=400307