The key is to define the chart's source data as a dynamic range.By doing so, the chart will automatically reflect changes and additions to the source data. First, we'll use the table feature, available in Excel 20-you'll be amazed at how simple it is. To do so, simply select the data range and do the following: Now, update the chart by adding values for March and watch the chart update automatically.Another approach is to add new data to the range not at the end, but somewhere within the range.
This works because the names you defined in steps 6 and 10 refer to a formula that calculates the extent of data in columns A and B of your worksheet.
There are many other ways that you can create dynamic ranges, depending on the characteristics of the data you are using.
If you add new data to the end of the range (after 11/13), then Excel doesn't know you want those items added to the chart.
Instead, insert some blank rows somewhere within the data range; it doesn't matter where, as long as the record for 11/13 is below the added rows.
You can then add the new data in the new rows, and the chart is automatically updated to include the data.