Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Sep 2008
    Location
    Virginia, USA
    Posts
    27
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Select Data in Excel 2007 will not update graph

    I use code in Access to copy query data to an Excel spreadsheet, then update graphs by Select Data, etc. to select all cells including the new data. This worked flawlessly in Excel 2003 but does not work in 2007 if I have more than one column of data. That is, Column A=month, Column B=# widgets: no problem, but if I also have Column C=#gizmos the updating will not work. I have sometimes used the painstaking one-step-at-a-time method to get all variables updated, but even that is not working lately. Any suggestion will be appreciated.

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    You mean you are manually changing the data source in Excel and the chart does not update?
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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