Folks,
I've been using Excel for a long time and have got used to the Charts updating whenever the data they drew upon changed. I had a spreadsheet in April which was monitoring a growing database. Every time I refreshed the pivot tables to reflect the new data entries then the charts I'd made from the pivot tables also changed.
Now however when I create a chart in Excel the charts no longer update. Even my old spreadsheet from April is like that too. I've looked on other forums and found some comments about getting your data recognised as a table, but that does not seem to work on my version of Excel. I'm curious that it seems to be a systematic problem.
I am using Excel 2011 for Mac version 14.7.7
many thanks in advance for any advice.
best
Dan
Bookmarks