print 2 or 4 charts per page in excel 2000

[Ashish Dwivedi]

Hi,

I have created a number of one page charts, each of which are located as
seperate sheets in one excel workbook.

I would now like to print 2 or 4 charts per page. However, I am unable to do
so. Do you know of automated way which would allow this to be done.

Your help would be appreciated.

Regards,
Ashish

 

[Jon Peltier]

Ashish -

The easiest way to do this would be to embed your charts in one or more
worksheets: right click on the chart, choose Location, then pick As
Object and select a sheet from the list. Then size and position them so
two or four charts fit into a printed page of the worksheet; use the Alt
key to align charts along cell boundaries. Don't select one of the
charts prior to printing, because Excel prints a selected embedded chart
as if it were a chart sheet. Instead define your print area, and select
some cell somewhere, then print the sheet.

- Jon