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

Solution

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:



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