need to stretch a pivot table longer than one page? :O)

[XCat]

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.

Thanks!!

 

[RoryA]

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.

 

[XCat]

the info from the table comes from another sheet in the same file.. does this answer? sorry, I'm kinda new to pivot tables.

I have it set up so that both a table and a chart was created from the information pulled (which was pulled from the existing excel file)

 

[XCat]

Hey sweet! I just copied it and put it in a new worksheet and now I can stretch it :O) That's one way to do it.

Thanks!!

 

[XCat]

Ok- I take it back, I could stretch it to my size, However, I lose one of the items from the pivot table.

The sheet is arranged from left to right as Machine, Operator, Time

But when I copy and paste the chart created by the table into a new spreadsheet to stretch it, the Machine is lost.

I've tried it both by clicking on the chart and cut, paste, and also by using the tab- Edit- copy -paste.

? Help please and thanks! :O)