automatically expand chart data series as data is added

[Guest]

I have several time series charts thta I update for each business day. I
would like the chart data series's to automaticallt expand as I add data.

 

[Andy Pope]

Hi,

You need to read up on dynamic named ranges.

http://peltiertech.com/Excel/Charts/Dynamics.html
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html
http://www.stfx.ca/people/bliengme/ExcelTips/Dynamic.htm

Cheers
Andy