Ive searched for this on the forum and there are numerous topics. HOwever i dont think they quite answer my query...
I have two Charts as separate worksheets.
I select both sheets and go to print - setup and select the multiple page option my printer has - 2 to 1.
I want both charts to appear on one single sheet.
I have done this before in the past but on a different pc and printer, with success.
Anyway, when i print, it prints the one page in portrait (correctly) with the first chart at the top of the page just as i would expect it, but then it leaves the second half of the page empty and continues to print the second selected sheet on a full page.
So i end up with both charts, one in half the size and one in full page size.
This is weird- never seen this before.
Tried it on another printer and it does the same, so im thinking it must be a setting somewhere, or im doing something wrong in excel.
I dont want to paste the charts as an object onto a separate worksheet as this would defeat my objective and take additional time.
Anyone else ever seen this?
Hi,
I've never been able to print out from separate sheets onto the same page without some manipulation - lucky you! ;-)
Like you say, any extra time needed is a nuisance but to the best of my (small) knowledge a work around of some sort is required. Ron DeBruin has a number of suggestions on his web page http://www.rondebruin.nl/print.htm & I think the closest to what you want would be: http://www.rondebruin.nl/print.htm#non-contiguous (using the picture link technique needs it only needs to be set up once).
hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...
Last edited by broro183; 08-31-2006 at 06:48 AM.
ok, guess this is a work around i`ll have to live with.
Weird how i can no longer get it to print through options!!
cheers for help
Pleased I could help :-)
Rob Brockett
Kiwi in the UK
Always learning & the best way to learn is to experience...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks