Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Make a smaller version of excel doc, 4 to a page?
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Make a smaller version of excel doc, 4 to a page?
Hi,
You probably don't actually need to shrink it down - its not the chart size that's critical its the ratio of the height to the width (about 3.5 to 5 works pretty well), after you make four copies and position them and follow the steps Joel gave you with regard to print settings, as long as you have specified the print area and set the printout to Fit to 1 by 1 pages. It should work pretty well. Tips: 1. To size and align charts to the spreadsheet grid drag them while holding down the Alt key. 2. Turn off the spreadsheet gridlines - Tools, Options, View, Gridlines 3. You might consider dropping the Margins to 0. 4. And centering vertically and horizontally on the page - page setup, margins tab 5. You can make a copy of a chart by dragging it with the Ctrl key down (in the spreadsheet. If this helps, please click the Yes button. Cheers, Shane Devenshire "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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you make cells smaller? | Charts and Charting in Excel | |||
Make a printable version of the Excel formula help page. | Excel Worksheet Functions | |||
is there a way to make an Excel file smaller than 296K? | Excel Discussion (Misc queries) | |||
why would page 1 of an excel worksheet print smaller of page 2 if. | Excel Discussion (Misc queries) | |||
Make Values Smaller Q | Excel Worksheet Functions |