Back to Tutorial

Lesson 12: How to Make Charts Auto Update

/en/excel-tips/using-the-quick-analysis-tool/content/

How to make charts auto update

When you create a chart in Excel, it's important to make sure it stays up to date, even if you add more data later on. Although you can manually adjust the chart's data range to include the new data, this can be tedious if you frequently update your spreadsheet.

Luckily, there is an easier way. Simply format your source data as a table, then create a chart based on that table. When you add more data below the table, it will automatically be included in both the table and the chart, keeping everything consistent and up to date.

Watch the video below to learn how to use tables to keep charts up to date.

/en/excel-tips/use-transpose-to-flip-data-on-its-side/content/