![]() |
Automated graph problem
I am creating automated graphs by updating ranges and moving objects in a VBA
loop with a time delay loop to slow it down (just doing a few thousand trig functions). After I make the changes, I refresh the chart. It normally works fairly well, but there are two problems: 1. The refresh periodically hangs up. The macro is still running but the graph does not refresh. (Stops different places different times) 2. Some of the object's sizes get distorted. I added an export to the loop to write each frame to a .jpg and the distortion really went crazy (on the display and in the jpg). If I take out the refresh and the timer loop the jpg files come out fine. I have tried it on several different computers with similar results. Using Excel 2003 in XP Pro Has anyone else experienced this kind of problem? Any suggestions? |
All times are GMT +1. The time now is 09:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com