Michael -

You can't spread a chart sheet over multiple printed pages, but a
worksheet will take as many pages to print as it needs.

Insert a blank workbook, switch to Page Break Preview (View menu).
Select a large area, and on the File menu, Print Area submenu, select
Set Print Area. Drag the blue borders around until this area is six
pages in size.

Switch to your chart. Choose Location from the Chart menu, and choose As
Object In, and select the new page from the drop down list. Align the
chart so its top left corner is in the top left of cell A1, and stretch
it to fill up the print area. Hold the Alt key while moving and resizing
the chart so its edges stick to the cell boundaries.

Now deselect the chart (select a cell) and print the worksheet. The
print area will print onto six pages, and the chart will be split
accordingly.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Michael wrote:
Hi All
My boss has compiled a list of 250 lines of data. He has put this into a
chart on A4.
He now wants the data to fit to A3 and 6 sheets wide. I know how to do it
with a normal sheet, but can someone help me with doing a chart.
All help is much appreciated.

Regards
Michael