ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Automated graph problem (https://www.excelbanter.com/excel-discussion-misc-queries/133776-automated-graph-problem.html)

danmck

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