PC Review


Reply
Thread Tools Rate Thread

copy chart delay (musa.biralo query)

 
 
Matthew Dodds
Guest
Posts: n/a
 
      10th Apr 2007
Back in December musa.biralo posted asking about why copy chart was so
slow.

I've just been working with this and found that while using
activesheet.ChartObjects(1).copy followed by a .paste within a with
worksheets clause is indeed very slow (~3 seconds), the exact same
outcome can be acheived using chtObj.chart.ChartArea.Copy followed by
the same .paste within a with worksheets clause ... but occurs without
perceptible delay. It appears that Excel recognises the need to
provide the chartObject object to accommodate the pasted ChartArea,
thereby removing the need to copy/paste this object along with the
ChartArea itself. It similarly appears that it's the copy/paste of the
chartObject object that takes the time.

Matthew

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy chart formatting and chart templates in Excel 2007 Astelix Microsoft Excel Charting 4 4th Mar 2010 04:10 AM
Delay copy & paste of data until web query refreshes? CM4@FL Microsoft Excel Programming 2 16th Apr 2009 06:00 PM
Time delay in displaying charts & chart names =?Utf-8?B?aGpzNDA=?= Microsoft Excel Charting 2 21st Oct 2007 08:55 PM
delay on copy =?Utf-8?B?a2x5eXNz?= Microsoft Excel Discussion 3 10th Jan 2005 03:52 PM
Copy/Time Delay Mike Microsoft Excel Programming 6 19th Oct 2004 02:26 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:20 AM.