Affiliate Disclosure: This article may contain affiliate links, which pay us a small compensation if you do decide to make a purchase based on our recommendation. I am hoping to retire from my full time job through writing so I can buy a cabin in the South Carolina mountains and become a career author.Our judgement is in no way biased, and our recommendations are always based on the merits of the items.
But you need to change or edit the number of the data every day, in this case, you have to update the chart manually so it includes the new data.Are there any quick tricks to help you auto update a chart when you add new data to an existing chart range in Excel?Auto update a chart after entering new data with creating a table Auto update a chart after entering new data with dynamic formula If you have the following range of data and column chart, now you want the chart update automatically when you enter new information.In Excel 2007, 2010 or 2013, you can create a table to expand the data range, and the chart will update automatically. Select the data range and click Table under Insert tab, see screenshot:2.In the Create Table dialog box, if your data has headers, please check My table has headers option, then click OK. And the data range is formatted as a table, see screenshot:4.
Now, when you add values for June, and the chart will be updated automatically. Your new entering data must be adjacent to the above data, it means there is no blank rows or columns between the new data and the existing data.2.
In the table, you are able to insert data between the existing values.
But sometimes, you don’t want to change the range to table, and the above method is not available in Excel 2003 or earlier version.
Here I can introduce you a complex dynamic formula method. First, you need to create a defined name and a dynamic formula for each column.
Click Formulas Note: In the above formulas, the OFFSET function refers to the first data point, and the COUNTA refers to the entire column of data.4.
After defining the names and formulas for each column data, then right click any column in your chart, and choose Select Data, see screenshot:5.