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