View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Make a smaller version of excel doc, 4 to a page?

1) If the chart is on a chart Sheet ( not a worksheet) then right click the
chart and select Location and choose the sheet you want to locate the chart.

2) Copy the chart and paste it 3 times. Move the charts so they are either
2x2 or 4x1.

3) Highlight cells behind charts making sure all the charts are within the
highlighted area.

4) From menu : File - Print Area - set Print Area

5) From menu : File - Page Setup - Fit to 1 page tall by 1 page wide

"whools" wrote:

I have a basic chart that I want to shrink down so I can print it 4 to a
page. Just basically want to make a smaller version of a sign that I can
pass out. How do I do this??? Thank you!