Chart - Help!

Is it possible to put two seperate (EXCEL) charts onto one
page for printing?
If so... how?

Gromit, I suspect Lori has two chart sheets she wants to combine onto a
single printed page.

Lori, right click on each chart in turn, select Location from the pop up
menu, click As Object In, and select a sheet where you want the charts.
Repeat for the other chart(s). To align charts, you can select them
both, and use the Alignment commands on the Draw menu (on the Drawing
toolbar). Alternatively you can hold down the Alt key while moving and
resizing charts (or other objects), and they will snap to the cell
boundaries.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Gromit wrote:
> Hi Lori,
>
> You have a couple of options.
>
> Firstly, you could just place the charts side by side, click View -
> Page Break Review and stretch the blue lines where you want them.
>
> A second approach is to create a dummy chart, by clicking on an empty
> cell, clicking the chart wizard and clicking Finish. Then choose Chart
> - Location - Create as New Object (Chart1, say). Next take your first
> real chart and go Chart - Location - Object In and select Chart1.
> Repeat for your second chart. The you can stretch and move the charts
> wherever you want on the page before printing.
>
> Hope this helps,
>
> Gromit
>
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~ View and post usenet messages directly from http://www.ExcelForum.com/
>