It doesn't look as if the 1 chart method applies when 2 charts are selected.
Rather, an ordinary sheet print is done.

If you want to print both charts on one sheet I don't think there is a real
easy way to do it. I'd do it like this:


1. Select the range that encompasses both charts (and no more) and select
File, Print Area, Set Print Area.
2. Hold the Shift key down and click the Print toolbutton to go into Print
Preview quickly.
3. If the charts take up more than one sheet or need to be enlarged to fill
up more of the sheet, click the Setup button you see in Print Preview and
adjust the "Adjust to" percentage until you are happy with the fit. You
might have to go back and forth between setup and the preview. You might
also adjust the page margins or anything else while you're there.
4. Print.

--
Jim
"nsv" wrote in message
...
|
| If I select one graph for printing it is automatically sized to fit the
| page and only the graph is printed. That's great.
|
| If I select two or more graphs then the whole bloody worksheet is
| printed, unless I carefully arrrange the two graphs on the background
| so that they have equal size, fit the page and after this carefully
| select the area to print.
|
| All this is quite tedious, particularly when thinking of jolly old
| Lotus where you could just select the two or more graphs and they were
| sized to fit page and all before printing.
|
| Is this Lotus method possible in Excel as well?
|
|
| --
| nsv
| ------------------------------------------------------------------------
| nsv's Profile:
http://www.excelforum.com/member.php...o&userid=26500
| View this thread: http://www.excelforum.com/showthread...hreadid=401063
|