Printing charts across more than 1 page

[Steph]

I would like to know if it is possible to print 1 chart
across more than 1 page, as the chart I'm working on has
500 items on the X axis.

I have tried to paste it into excel and expand it from
there but I can't get it to print out.

 

[Jon Peltier]

Steph -

I think I would try to make 5 charts with 100 items each, or some
similar break down. At least that way, each page gets a Y axis.

You could embed the chart in a worksheet (right click the chart, choose
Location from the popup menu, check Object, and pick the sheet from the
list). Then change to Page Break preview, and stretch your chart to
fill several pages. Now print the worksheet.

- Jon