If you add a row or two of data to your spreadsheet, you can easily update the Excel chart pertaining to that data by changing the chart's data range. However, if you find yourself continually changing the data range, you may want to set up the chart so that it automatically updates as new data is added.
Suppose you are
keeping track of the maximum temperature for each day in April. You have
entered the first two dates for April in Column A, which contains the field
name Date in A1. The corresponding temperature for each day will appear in
Column B, which contains the field name Temperature in B1. Thus, you enter 55
in B2 for
- Go to Insert | Name| Define.
- Enter Date in the Names In Workbook text box.
the following formula in the Refers to text box:
- Click Add.
- Enter Temperature in the Names In Workbook text box.
the following formula in the Refers To text box:
- Click Add and then OK.
- Click on the chart, and then on the data series.
the formula in the formula bar to the following:
The chart will update automatically each day with a new temperature. Be sure you don't use Columns A and B for any other data; otherwise, COUNTA will return an incorrect value.
Miss a tip?
Check out the Microsoft Excel archive, and catch up on our most recent Excel tips.
Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.