I have 16 graphs. How do I print four to a page?

A

Andy Pope

Hi,

You will need to relocate the chart sheets, in 4's, either on to a
worksheet or blank chart sheet.
When printing each new chart sheet automatically causes a page throw.

Cheers
Andy
 
A

Ayo

1. Select any blank cell in the worksheet and press F11. This creates an
empty Chart sheet to hold the embedded charts.
2. Reactivate your worksheet, click an embedded chart, and select
Chart>Location to display the Chart Location dialog box.
3. In the Chart Location dialog box, choose the As Object In option and
specify the empty Chart sheet. Excel transfers the embedded chart to your
Chart sheet.
4. Select your remaining charts and choose Chart>Location to move them to
the Chart sheet. Note that you must move each chart separately. (You can't
select multiple charts.)
Putting multiple charts on a single chart sheet lets you use the View>Sized
with Window command (available when the Chart sheet is active) to scale the
charts to the current window size and dimensions.
 
R

Rob L

An easier way is to select each graph in turn, and copy a linked picture of
each graph onto one sheet. You can then set up the sheet to print as many
graphs as you like per page.

To do this...
Select a graph, and CTRL+C. Go to a blank worksheet, hold down the SHIFT
key, and click on Edit>Paste Picture. This pastes a linked "picture" of the
graph. If your graph changes, so does the picture. Do this for each graph,
and resize, position do whatever you like to the pictures so they print how
YOU want.

Regards,

Rob Lepper
 
Top