Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Chapel Hill, North Carolina, USA
    Posts
    138
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Charts does not update (Excel 2007 (Mac 2004))

    I have a chart based on a table of data. The data is changed by modifying one of several cells with constants used in formulas in the table. When I change a constant (such as interest rate), the data in table changes, but the chart does not update. I am teaching an Excel class and most of the students have charts that automatically update when the data does, but a small number - on both Macs and PCs have data that changes in the table, but not in the chart. Is there a setting in Excel Options that needs to be changed?

    Thanks!

    Larry

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Charts does not update (Excel 2007 (Mac 2004))

    Charts should always reflect changes in the source data automatically.

    Could you post a stripped down copy of the workbook that demonstrates the problem? Replace sensitive information with dummy data.

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Charts does not update (Excel 2007 (Mac 2004))

    In the ones not updating does <F9> update the chart? [The question being: Are the calcuations set to manual? (tools - options - calculation).]

    Charts don't update automatically unless the worksheet calculates automatically...

    Steve

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Charts does not update (Excel 2007 (Mac 2004))

    But Larry states that the source table does get updated, so it would seem that calculation is on.

  5. #5
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Chapel Hill, North Carolina, USA
    Posts
    138
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Charts does not update (Excel 2007 (Mac 2004))

    Thanks to both - we did check that calculations are automatic (and the table does update) - it's really odd - I have 40-50 students and this happened to only 3-4 of them....I'll try to recreate and send to you. First, we'll reboot Excel and then try the spreadsheet on another PC.

Posting Permissions

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