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.

Simple table


The chart can be simple like this:

Chart from simple table


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.

Format as Table menu


See this on video tutorial:

Add a comment »One comment to this article

  1. I want to update my graph after my table grows. This can be the way. It is great that I dont need a VBA macro. How it works when I put new row into table not in the end?


Copyright © All Rights Reserved · Green Hope Theme by Sivan & schiy · Proudly powered by WordPress