Line Chart only prints to 1 page

[Dan Clarke]

Hi all,

When creating a Line Chart in Excel 2002 (SP3) the Chart
will only Print to 1 page.

This is difficult to read as there are around 8000 dates
in the X Axis.

How do I get the Chart to print over multiple pages?
Excel 97 allowed me to print over multiple pages, but I
don't want to downgrade.

Thanks,

Dan

 

[Jon Peltier]

Dan -

You have to stretch the chart to cover a worksheet range as large as you
want to print, then print this range of the sheet. If you select the
chart and start the printing process, it will fit the chart to a single
page.

In this regard, the later versions of Excel work in the same way as '97.

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