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: 1
Default arranging charts and visible screen size

i have a set of procedures that output multiple charts to a particular
worksheet. At the moment all the charts are centered on the sheet on
top of each other. I'm thinking this is a long shot, but is there a
way to automatically (and programmatically) arrange these charts on the
page? Kind of like what Windows/Arrange.../Tiled does for workbooks?

I think more realistic would be doing the math myself to arrange the
charts. So to that end, how would I find the size of the visible area
of the spreadsheet (the part not including the toolbars, menu bar, etc
etc). I would use this to set the Top, Left, Height, Width properties
of the charts.

Anyone have a better way of doing this or already have some code that
does something similiar? Thanks a lot guys.

--
ThatFella
 
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
Problems with Visible and Screen Dave Excel Discussion (Misc queries) 0 January 4th 08 02:32 PM
change font size on screen, but prints in old size lvrcdval Excel Discussion (Misc queries) 2 July 19th 07 02:36 PM
Work sheet size relative to screen size Florida Tom Excel Discussion (Misc queries) 1 April 16th 07 02:22 AM
arranging excel tabs (charts vs worksheets)in multiple rows/dimens ajk2 Charts and Charting in Excel 0 August 24th 05 03:22 PM
color not visible on screen TJTOMCIU Setting up and Configuration of Excel 1 January 2nd 05 05:59 PM


All times are GMT +1. The time now is 03:52 PM.

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"