Chart: Automatic update when data source changes
Chart created from a simple data table is static and when the source changes, the chart has to be update manually. There is a possibility how to update the chart automatically. Table on the following picture is the source of the chart.
The chart can be simple like this:
Excel 2007 and higher contains menu Format as Table. Chart, created from such a table, updates itself when you add rows or columns. So, just select the table and choose one of the styles from Format as Table.
See this on video tutorial: