How do i rotate a pivot table?

collinsc

Board Regular
Joined
Sep 13, 2006
Messages
230
I hope this is an easy one?
I have a pivot table with projects across the columns and months down the rows. i need to chane it so that the projects are rows and the months are columns.
Is there an easy way to rotate it 90 degrees?

i though i could just drag the row field to column field and vice versa- but it takes some of the formatting off... i.e. if i drag it the date data goes in row format instead of column format.!

thanks
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Jon von der Heyden

MrExcel MVP, Moderator
Joined
Apr 6, 2004
Messages
10,808
Office Version
  1. 365
Platform
  1. Windows
Are you sure you're dragging it to the correct segment? Try doing it in the wizard; right-click pivot table -> wizard -> layout.

Regards,
Jon :)
 

collinsc

Board Regular
Joined
Sep 13, 2006
Messages
230
i am able to get the data on the pivot table- just not the way i want it...!
i want it like this:
APR MAY JUN JUL AUG......................
001 004 002 003 009.........................
001 002 005 004 008...........................

If you know what i mean?
i reckon its something to do with COUNT or SUM?
 

Jon von der Heyden

MrExcel MVP, Moderator
Joined
Apr 6, 2004
Messages
10,808
Office Version
  1. 365
Platform
  1. Windows
Hmmm could you post a sample of the source data? Preferably with Colo's HTML maker...
 

collinsc

Board Regular
Joined
Sep 13, 2006
Messages
230

ADVERTISEMENT

I am at work so unfortunatley cannot dl the HTML maker. I will attempt to type an example...

DATA PRJ: A12345 B12345 C12345 D12345
Count of Sep 06 06 09 04 08
Count of Oct 06 04 10 07 02
Count of Dec 06 08 07 02 06

Hope this gives you some idea?
i want it to read like...
PRJ DATA: Sep 06 Oct 06 Nov 06 Dec 06
A12345 06 09 04 08
B12345 04 10 07 02
C12345 08 07 02 06
 

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Hi

If you right-click on the Data descriptor, navigate to Order and you should see an option to "Move to Column".

Richard
 

collinsc

Board Regular
Joined
Sep 13, 2006
Messages
230
Ok- i now have a follow up questions!
it says "count of sep 06" can i rename it so it says "sep 06" ???
i cant do it within the pivot table... is there a renaming area?
 

Forum statistics

Threads
1,136,630
Messages
5,676,880
Members
419,657
Latest member
ExcelAl1

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top