Question

When you change the data and text in a worksheet, Excel automatically updates the chart.​

Answer 1

Explanation:

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 4/1/06 in A2, and 60 in B3 for 4/2/06 in A3. You select A1:B3, and create a chart for Maximum Daily Temperatures for April. To have the chart update automatically as each new row is added daily, follow these steps:

Go to Insert | Name| Define.

Enter Date in the Names In Workbook text box.

Enter the following formula in the Refers to text box:

=OFFSET(Sheet1!$A$2,0,0,COUNTA(Sheet1!$A:$A)-1)

Click Add.

Enter Temperature in the Names In Workbook text box.

Enter the following formula in the Refers To text box: