can my chart update itself if i add data?

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.

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 <[email protected]>,
[email protected] 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
>
>