print 2 or 4 charts per page in excel 2000

  • Thread starter Thread starter Ashish Dwivedi
  • Start date Start date
A

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
 
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
 
Back
Top