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:
http://img144.imageshack.us/img144/3...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!
Bookmarks