+ Reply to Thread
Results 1 to 2 of 2

Position of graph affects performance

  1. #1
    Registered User
    Join Date
    04-24-2004
    Location
    Wisconsin, USA
    MS-Off Ver
    2007
    Posts
    71

    Position of graph affects performance

    I have an Excel 2007 spreadsheet where I track investment accounts. I have a sub-routine that updates a chronological list of values which is used to graph the progress. For the most part it works fine.

    My question:
    The routine runs quite quickly – around one second. However, if I reposition graph location by moving it up on the worksheet, the routine slows down. Sometimes it takes 4-5 seconds to complete (no biggie) but I’ve seen it slowdown to over 30 seconds. If I move the graph back to the original position it returns to a one second process. If I move the chart down, left, or right (just not up) the speed is not affected. Any suggestions would be appreciated?

    Thanks,
    Steve
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    04-24-2004
    Location
    Wisconsin, USA
    MS-Off Ver
    2007
    Posts
    71

    Re: Position of graph affects performance

    I believe I found my answer. I added the line
    "application.screenupdating = false"
    to the beginning of the sub-routine.

+ 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. Replies: 0
    Last Post: 10-03-2014, 07:51 AM
  2. Graphing seasonal performance (line graph)
    By oifla in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-09-2013, 02:23 PM
  3. Graphing seasonal performance (line graph)
    By oifla in forum Access Tables & Databases
    Replies: 0
    Last Post: 10-08-2013, 02:03 PM
  4. Creating a graph to chart business performance
    By md1972 in forum Excel General
    Replies: 2
    Last Post: 08-23-2010, 09:45 PM
  5. how to make a graph/snapshot of budget performance
    By kate1803 in forum Excel General
    Replies: 5
    Last Post: 08-05-2010, 08:09 AM
  6. how to make graph/snapshot of budget performance
    By kate1803 in forum Excel General
    Replies: 3
    Last Post: 08-05-2010, 06:26 AM
  7. print a league performance graph
    By brucieboy1966 in forum Excel General
    Replies: 8
    Last Post: 11-13-2007, 11:45 PM

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