+ Reply to Thread
Results 1 to 4 of 4

Charts no longer update

  1. #1
    Registered User
    Join Date
    06-11-2021
    Location
    Glossop, UK
    MS-Off Ver
    2011 for Mac
    Posts
    3

    Charts no longer update

    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

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,598

    Re: Charts no longer update

    Check that your Calculation Options on the Formulas tab is set to Automatic rather than Manual.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    06-11-2021
    Location
    Glossop, UK
    MS-Off Ver
    2011 for Mac
    Posts
    3

    Re: Charts no longer update

    Thanks Pete, it is set to Automatic - that's part of the mystery

    best

    d

  4. #4
    Registered User
    Join Date
    06-11-2021
    Location
    Glossop, UK
    MS-Off Ver
    2011 for Mac
    Posts
    3

    Re: Charts no longer update

    Further to my last, I've just tried the obvious thing - shut down Excel and start it up again. Now all the charts are updating. . Thanks to Pete for your engagement with my query

    d

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Dougnut and pie charts no longer round in shape!
    By Morgan Laplonge in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-09-2019, 04:12 PM
  2. VBA charts update - dynamically test sheet type for two types of charts
    By kapucino in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-07-2017, 07:00 AM
  3. Pivot charts no longer work correctly at change of year
    By SJMaye in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-15-2016, 06:54 AM
  4. VBA & CSV (Post Office Update) - VBA no longer working
    By stevenchapman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-24-2015, 08:13 AM
  5. Charts no longer viewable
    By jdwilson in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-17-2008, 11:35 AM
  6. [SOLVED] Formulae in spreadsheet no longer update with new data
    By Stevej47 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-17-2006, 01:10 PM
  7. How do I stop using data source no longer needed for charts?
    By Grace in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-21-2005, 02:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1