Excel charts

[Patrick Flanigan]

I am attempting to find a way to display multiple charts
on the same page. Currently I am cutting-and-pasting the
individual charts to a Word document. This is proving to
be an inexact science and very time-consuming.

Is there a method to display multiple (four in this case)
charts on one page and have each chart the same size, etc.
without extensive resizing by hand?

Thanks for your help. Just FYI: This is common problem
that many Excel users in small and large organizations run
into.

Patrick Flanigan
(e-mail address removed)
412-409-9100 ext 268

 

[Jon Peltier]

Patrick -

You can do this easily if you put the charts on a worksheet. I often use
a blank worksheet for this. Insert a blank sheet, then right click on
each chart, choose Location from the pop up menu, and pick As Object In
and choose the new sheet from the drop down list. When all the charts
are there, you can move and resize them the way you like. I usually run
Page Setup from the File menu first, so I can see the page breaks and
align the charts accordingly. If you hold the Alt key while dragging and
resizing a chart, its edges will stick to the cell boundaries, making it
easy to get same-sized charts.

- Jon