I get the impression that your problem is not so much getting multiple
charts on one sheet, but printing more than one per page. If that is indeed
the case, you can do either one of the following:
- instead of selecting a chart, select the range of cells containing the
charts you want to print, or
- select one chart, then hold down the Ctrl key while you select the others
that you want to plot.
Since Excel still defines a rectangular print range if you use the second
method, you might find that some charts print that you did not select.
However, by re-arranging them and/or playing around a bit (with scaling, page
breaks, etc.), you should be able to get what you want.
Good Luck!
Hugh John Cook
"ledmari" wrote:
I'm trying to place several charts in the same sheet, but I can't make it
work. I don't want to print one page for each chart, instead i want to
reduce the number of pages by placing 4 or more charts in the same sheet.
How can I do it?
|