|
If you make your data a list (table in 2007) and base the chart on that it will automatically extend.
Otherwise you can create dynamic named ranges and use those as the series data source. There are many examples of dynamic named ranges on the site, so use the search. If you still have questions post back.
|