What happen to a chart when you change data or text in a worksheet?
Answers
Answered by
8
Answer:
Create an Excel chart that automatically updates with new data
Go to Insert | Name| Define.
Enter Date in the Names In Workbook text box.
Enter the following formula in the Refers to text box: ...
Click Add.
Enter Temperature in the Names In Workbook text box.
Enter the following formula in the Refers To text box: ...
Click Add and then OK.
Click on the chart, and then on the data series.
Similar questions