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.