How do I auto-expanding SourceData range for charts

[Vince]

How do I auto-expand the SourceData range for charts when
I add a new row to my data table. I have 49 charts that
take 49 data tables. I'd like to be able to just add a new
row to each table and have the charts automatically expand
their SourceData ranges. Thanks.

 

[Jon Peltier]

Vince -

You can have your chart autoexpand when data are added. This is done
for each series, not for the source data all at once, using dynamic
defined names as the chart series data, as described in a couple
examples and a lot of links on my web site:

http://www.geocities.com/jonpeltier/Excel/Charts/Dynamics.html

You would need a VBA solution if you needed to add series when the range
expanded.

- Jon