• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How can I put 2 pivot tables within the same sheet on a workbook

L

lwilt

Member
How can I put 2 pivot tables within the same sheet on a workbook. One I have a pivot table in a workbook and try creating a new pivot table and adding it the sheet with the first workbook it won't allow me.


help please


Logan
 
When you get to the point in Pivot Wizard where it asks where you want to put it, choice should be either a new sheet or existing sheet. If you choose the latter, you must choose the "anchor point", ie. the top left cell of PivotTable. Make sure you pick a point that won't overlap w/ the previous PivotTable.
 
Ohhh ok I didn't realize you had to pick the cell within the worksheet. I was just trying to assign it to the sheet I wanted.


thank you
 
You must log in or register to reply here.
Back
Top