Automatic updating graphs in excel
You can refresh the data for Pivot Tables connected to external data, such as a database (SQL Server, Oracle, Access, or other), Analysis Services cube, data feed, and many other sources.
You can also refresh data from a source table in the same or a different workbook.
Wouldn’t it be cool if the ranges were dynamic and charts get updated automatically when you add (or remove) rows? If you are using Excel 2003 or above you can create a data table (or list) from the chart’s source data.
Well, you can do it very easily using excel formulas and named ranges. This way, when you add or remove rows from the data table, the chart gets automatically updated.
In Power Point, when the mouse pointer is on a slide, the familiar insertion rectangle appears.