1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Chart not reflecting changes to data

Discussion in 'Discuss Data Visualizations and Charting' started by SimonK, Feb 16, 2018.

  1. SimonK

    SimonK New Member

    Messages:
    15
    Hello Everyone, I hope there is a simple explanation for this issue:
    I am working on a soil water balance model in Excel and I need to manually adjust monthly variables attempting to match real collected data.

    When I change a value, the chart was updating but is no longer. The only way I've found to recognise the change in the chart is to change datasets and then change it back again. Then I can see the change. (This is tedious)

    Is there any tricks people know to refresh the plot of a chart?

    The file is pretty big and I'm not at liberty to share the file but I have uploaded a screen shot of what I'm working on.

    Attached Files:

    Last edited: Feb 16, 2018
  2. Hui

    Hui Excel Ninja Staff Member

    Messages:
    11,351
    Use Named Formulas "Named Ranges" to select the data and base the chart on these

    As data is added/removed they will update
    SimonK likes this.
  3. SimonK

    SimonK New Member

    Messages:
    15
    Thanks Hui, I'll have to trust that you're right but this sheet is quite complicated and there are lots of named ranges in the mix and some that aren't named too so it will take some time to work through it all. Cheers
  4. Hui

    Hui Excel Ninja Staff Member

    Messages:
    11,351
    I didn't get to 11,035 posts by giving people bad advice

    There are many issues that can stop charts updating, but the main culprit is incorrect data ranges

    Use of Named Formulas is a solution that helps that issue

    Of course without a file to actually see, I may be totally wrong
    SimonK likes this.
  5. SimonK

    SimonK New Member

    Messages:
    15
    Indeed! Love your work Hui. You are a global Excel treasure!

Share This Page