Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default Stopping blank page printing


Hiya, my charts are causing bother again!

This time pertains to printing. I have a bunch of stacked charts, each
with visible contents that'll fit on a single-width page. The
chartarea, however, has to (by coding imperative) cross the vertical
pagebreak, but the bit outside never has any visible material in. You
can see this situation here, with one of the chartareas highlighted:
'[image:
http://img144.imageshack.us/img144/3558/graphpageoverlaphe3.th.png]'
(http://img144.imageshack.us/my.php?i...overlaphe3.png)

Now, this causes Excel, when printing, to feed out a bunch of blank
pages. Which wouldn't be so bad, but the footer page counts gets all
screwed up and the Earth dies a little more. Is there a way to tell
Excel to ignore pages with nothing on when printing? Or perhaps to mark
the chartarea (but not plotarea) as a non-printable object?

Thanks!


--
F*SH
------------------------------------------------------------------------
F*SH's Profile: http://www.excelforum.com/member.php...o&userid=36355
View this thread: http://www.excelforum.com/showthread...hreadid=564228

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
First column not printing after 1st page. cridhe1 Excel Discussion (Misc queries) 1 February 10th 06 05:36 PM
page set up on excel to get 100% @ time of printing music icons Setting up and Configuration of Excel 0 January 10th 06 08:40 PM
Determining and Printing a specific page wnfisba Excel Discussion (Misc queries) 3 December 21st 05 04:16 PM
How can I do one-time printing without set page breaks? kewlblondboy Excel Discussion (Misc queries) 2 August 24th 05 02:53 PM
Printing Recto/Verso Sam Vanderstraeten Excel Discussion (Misc queries) 2 July 7th 05 12:44 PM


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