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.
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.
Shading between plotted lines with a light color can enhance some charts.
The shading may help to indicate a target range for the data.
Supposing you have created a chart to track the daily sales based on a range of data in your workbook.
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.