Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy chart delay (musa.biralo query)
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time delay in displaying charts & chart names | Charts and Charting in Excel | |||
Copy/Paste in Excel Delay | Links and Linking in Excel | |||
Query Wizard Long Delay in Excel 2003 | Setting up and Configuration of Excel | |||
web query help.. delay? | Excel Worksheet Functions | |||
Copy/Time Delay | Excel Programming |