Anyway to easily and neatly print out multiple graphs in excel?

[LordJezo]

I have a worksheet with 8 graphs on it and I want to print them out neatly, maybe 2 to a page. When I try to print them excel just dumps them across multiple pages and makes a mess out of all of them...

 

[Ness]

copy and paste the graphics into word.

You can easily resize them to fit 2 on a page.

Unless you need info on there still...

Then it's a matter of figuring out how many rows/column are printing per page and sizing the graphics to fit into those proportions.

 

[MrMilney]

Set the print area to encompass the charts in question, then use page break preview to tweak where the page breaks occur. That should give you exactly what you are looking for.

 

[LordJezo]

Tried that Minley.. but, unless I move the charts to be lopsides excel auto moves the page breaks to cut the graphs in half. if i move the chart down an inch the page break dissapears and doubles in size.

 

[RayH]

Layout the graphs in 1 column vertically or 2 wide x 4 tall depending on landscape or portrait. Select the all the graphs for the print area, then go to Page Setup and adjust the Scaling to fit to 1 page wide by 4 tall. Preview and play with margins and graph sizes if necessary to fill page.