I have some charts that need weekly update, is there a way for me to update
these charts automatically across sheets in my workbook - Whenever new rows
of information are entered in my table.

I normally drag the old reference cells to the new cells to get the chart
updated. If anyone can help me I will be totally grateful.

Thanks a lot.

If using Excel 2003, convert the data range to a list (Data menu > List >
Create List). In 2007, convert the range to a table. When you add data to a
list or table, any formulas, including chart series formulas, update to the
new size of the list or table.

If you're using a previous version, use dynamic ranges to create a dynamic
chart:

http://peltiertech.com/WordPress/200...ynamic-charts/

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Yossy" <(E-Mail Removed)> wrote in message
newsF788DD8-84BF-4F0A-A663-(E-Mail Removed)...
>I have some charts that need weekly update, is there a way for me to update
> these charts automatically across sheets in my workbook - Whenever new
> rows
> of information are entered in my table.
>
> I normally drag the old reference cells to the new cells to get the chart
> updated. If anyone can help me I will be totally grateful.
>
> Thanks a lot.