LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
Tim Tim is offline
external usenet poster
 
Posts: 8
Default resizing and moving chart elements

Hi All,

I am programatically creating a report which includes a number of
graphs. Depending on the report the position and size of elements
within the charts( ie the plot area, title and legend) may change. My
problem is that if I turn screen updating off to speed up the code the
charts do not update. I have searched the newsgroups and have tried
calling the sub that resizes /moves the chart elements multiple times
as has been suggested(Which didn't work). I have also tried running the
sub after screen updating has been turned back on and this works but
only for the charts visible on the screen. If I run the sub manually
after the report has been written it works but I do not want to do this
as the final user may not be bothered clicking two buttons to get the
report. My final solution has been change the code to zoom out and
scroll page by page through the report updating the visible graphs
unitll all have been updated( which works but doesn't look very flash).
My question: has anyone else experienced this sort of thing before and
been able to solve it without turning screenupdating back on first?

Apoligies for the long rambling post

Any help much appreciated

regards

Tim

 
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



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