Hi there, it's probably simple, but I and everyone else here can't figure out why I can't grab a point of the chart and stretch it (resize it) longer than one page. There is too much information for one page to be readable.
Where does the pivot table come into it?
If your chart is a separate chart sheet, you could change it to be embedded in a worksheet, and then you can make it as big as you like. If you have that much data on it though, you may want to rethink the layout.