LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Automated graph distortion

I posted this under misc and got no response so thought I would try here.

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?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Graphing distortion Jase Excel Discussion (Misc queries) 2 April 8th 08 11:05 PM
Automated graph problem danmck Excel Discussion (Misc queries) 0 March 7th 07 06:51 PM
distortion while printing Haresh Charts and Charting in Excel 1 February 19th 07 08:09 AM
Automated task to present data in a graph form. luckyguy Charts and Charting in Excel 1 November 3rd 05 12:20 PM
Automated task to present data in a graph form. luckyguy Charts and Charting in Excel 1 November 2nd 05 10:51 PM


All times are GMT +1. The time now is 02:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"