Auto-Update a Chart after Entering New Data in Excel using Tables

If we convert the above dataset into a Table then no matter what we add to it, the chart will be updated automatically.

Step 1: Select the entire dataset and click on Insert on the top of the ribbon and then select Table. The following dialog box opens.

Remember to check: My table has a headers option is checked. Headers are the column names such as Student Name, DSA, OS, etc. Now our dataset is a Table, now whenever we add any new values to the table like rows or columns or add columns our plot will get updated.

Step 2: Now select the entire table and from Insert click on any type of chart the user like. Here Plot is generated with the default dataset.  

Step 3: Then add a new row or column or change any value and see the plot which automatically changes. After Adding a new Row with some values.

Video Output of the Process

When you build a chart in Excel, it’s challenging to keep it up to date, even if you subsequently add new data. Although you may manually alter the chart’s data range to reflect the new data, this can be time-consuming if your spreadsheet is constantly updated. Fortunately, there is a simpler approach. 

To save you time, Simply prepare your source data as a table before creating a chart based on it. When you add new data below the table, it will be reflected in both the table and the chart, keeping everything consistent and up to date. 

In this article, we will discuss how to auto-update a chart in Excel after entering any new data into it. Users must be familiar with Excel and the type of charts possible to make in Excel.