Question: how to create a pie chart in excel that updates automatically?
Answer: 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.