Question

does a chart automatically update itself if the worksheet data is updated​

Answer 1

Explanation:

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:

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

Click Add and then OK.

Click on the chart, and then on the data series.

Change the formula in the formula bar to the following:

=SERIES(,Sheet1!Date,Sheet1!Temperature,1)

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.

Answer 2

Answer:

Now the chart updates automatically regardless of where you add information in your data table. 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 workshee

Explanation:

Hope it helpfull