2 pivot tables on one tab
 

Is it possible to put 2 Pivot tables on the same tab in my workbook?
Or does anyone have any ideas on what would be the best way to chart Capital
Pircahses? I have 5 coums and 4 rows. The rows are per division, and the
columns are for the disposal amount, gain or loss, book value, depreciation &
purchase price. I already have one pivot table in my report. Would this be
too repeatative?
Thanks

2 pivot tables on one tab
 

You can put multiple pivot tables onto a worksheet. If the second one is
based on the same data, select and copy the first, select a cell some
distance away, and paste it. Each pivot table can then be pivoted based on
different criteria.

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


"Pam" wrote in message
...
Is it possible to put 2 Pivot tables on the same tab in my workbook?
Or does anyone have any ideas on what would be the best way to chart
Capital
Pircahses? I have 5 coums and 4 rows. The rows are per division, and the
columns are for the disposal amount, gain or loss, book value,
depreciation &
purchase price. I already have one pivot table in my report. Would this
be
too repeatative?
Thanks

2 pivot tables on one tab
 

My second table ios not based on the same information. Once I copy and paste
the pivot table, can I change where the information is coming from? won't
that change both the tables?

"Jon Peltier" wrote:

You can put multiple pivot tables onto a worksheet. If the second one is
based on the same data, select and copy the first, select a cell some
distance away, and paste it. Each pivot table can then be pivoted based on
different criteria.

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


"Pam" wrote in message
...
Is it possible to put 2 Pivot tables on the same tab in my workbook?
Or does anyone have any ideas on what would be the best way to chart
Capital
Pircahses? I have 5 coums and 4 rows. The rows are per division, and the
columns are for the disposal amount, gain or loss, book value,
depreciation &
purchase price. I already have one pivot table in my report. Would this
be
too repeatative?
Thanks

2 pivot tables on one tab
 

Hi Pam,

you can do it either way. Maybe the easiest for your case:
1. Create the first pivot table from the 1st data set
2. Select the second data set and go through to the 3rd step of the wizard
a. If the data for this second table comes from the same sheet where the
first pivot table is just indicate that you want the pivot table in an
Existing worksheet and then indicate the cell.
b. If the data for this second pt comes from a different sheet, just
indicate that you want the pivot table in an Existing worksheet and then
click the tab of that sheet and then the cell in that sheet where you want to
place it.

Alternatively, Create the two pivot tables on their own sheets. Then
select one of the pivot tables and choose Cut, move to the other sheet and
choose Paste.

There are other ways as well.
--
Thanks,
Shane Devenshire


"Pam" wrote:

My second table ios not based on the same information. Once I copy and paste
the pivot table, can I change where the information is coming from? won't
that change both the tables?

"Jon Peltier" wrote:

You can put multiple pivot tables onto a worksheet. If the second one is
based on the same data, select and copy the first, select a cell some
distance away, and paste it. Each pivot table can then be pivoted based on
different criteria.

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


"Pam" wrote in message
...
Is it possible to put 2 Pivot tables on the same tab in my workbook?
Or does anyone have any ideas on what would be the best way to chart
Capital
Pircahses? I have 5 coums and 4 rows. The rows are per division, and the
columns are for the disposal amount, gain or loss, book value,
depreciation &
purchase price. I already have one pivot table in my report. Would this
be
too repeatative?
Thanks