Results 1 to 3 of 3

Thread: Excel 2007 charts are not updating at all

  1. #1
    Join Date
    Oct 2011
    Posts
    60

    Excel 2007 charts are not updating at all

    As new data is input the chart remains the same and doesn't reflect new data. The data values and number of entries can be completely different. I think there is a setting somewhere to automate the chart update but I can't find it. Can anyone please help me.

  2. #2
    Join Date
    Jul 2011
    Posts
    440

    Re: Excel 2007 charts are not updating at all

    If you are adding data below the range pointed to by the chart, then the chart won't update. If you put the source data in an Excel Table, then the chart will update. Otherwise, you're going to have to click on the chart & drag the range indicators down to increase the # of rows used.

  3. #3
    Join Date
    Aug 2011
    Posts
    460

    Re: Excel 2007 charts are not updating at all

    I have run into this problem too. What solved it for me was this: make sure that the field (column) references for your horizontal X-axis labels is the same as the field (column) references for your other data. If your field reference for x-axis labels ends before the field reference for your other data, the most recent data points won't appear in your graph.

Similar Threads

  1. Replies: 1
    Last Post: 13-02-2012, 07:49 PM
  2. Not able to View, Modify, or Create Charts in Excel 2007
    By Script in forum Windows Software
    Replies: 5
    Last Post: 16-05-2011, 10:21 AM
  3. Problem Inserting Charts in Office 2007
    By Duncan McC in forum MS Office Support
    Replies: 1
    Last Post: 13-02-2010, 10:36 AM
  4. How to find slope in Line Charts in Excel
    By Amelia in forum Windows Software
    Replies: 3
    Last Post: 04-02-2009, 03:25 PM
  5. Bubble Charts in PowerPoint 2007
    By Nickason in forum MS Office Support
    Replies: 2
    Last Post: 08-05-2008, 04:46 AM

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
  •  
Page generated in 1,711,660,866.59257 seconds with 17 queries