Data Label of Pie Chart Does Not Refresh when I enter new data the pie chart should automatically update with teh new totals but it doesn't. I have tried to reset the data labels but it appears to only be a temporary fix. Can anyone please help? thanks
Data Label of Pie Chart Does Not Refresh
0
Post Edited
Tags: Tags were updated to reflect the topic of the question.
Discussion
Please attach a workbook with the faulty pie chart in it to your question.
Variatus (rep: 2523) Aug 8, '18 at 7:52 pm
Answers
0
Sounds like you have automatic calculations turned-off.
Does it refresh when you hit F9? If so, then go to the Formulas tab > Calculation Options (on the right side of the ribbon menu) > select Automatic.