Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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?
Reply
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
Graph Problem Saxman Excel Discussion (Misc queries) 0 November 19th 05 05:31 PM
Automated task to present data in a graph form. luckyguy Charts and Charting in Excel 1 November 3rd 05 01:20 PM
Automated task to present data in a graph form. luckyguy Charts and Charting in Excel 1 November 2nd 05 11:51 PM
problem with dynamic graph [email protected] Excel Worksheet Functions 1 April 11th 05 08:30 AM
Precision problem with automated formula fill-in Erny Meyer Excel Worksheet Functions 1 February 4th 05 02:22 PM


All times are GMT +1. The time now is 06:32 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"