Pivot Table question - again - signed it this time

Paul-Johnson

New Member
Joined
Feb 22, 2002
Messages
47
Is there us a way to sort the columns in a pivot table ?

Below is a simple example (my real data is much more complex)

Cat <100
Mouse <100
Dog 100-500
Rabbit 501-1000
Hamster 501-1000
Elephant > 1000
Giraffe > 1000

When I create the pivot table

The rows are the animals listed, the columns are the values listed, and the data is the count of each value.

Unfortunately, the columns come out in the following order:
> 1000
100-500
501-1000
< 100

Is there a way to change the order in which they appear, other than changing the source data ? In reality there are 30,000 + items.

Your help is appreciated.

PJ
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
Click on each Item in your PivotTable, grab hold of its column boundary, and drag it to the desired position.
 
Upvote 0
Maybe I am being dumb. But, when i try select the column of data and try to move it via the handlebars, i get an error message saying that operation cannot be performed.
 
Upvote 0
Ahh, now I understand your problem. There shouldn't be a fill handle after you make the proper selection. Evidently, the Enable Selection mode has been disabled. Right click on your PivotTable and choose the Select | Enable Selection popup menu command. The icon should appear depressed (but, not in need of Prozac :), Sorry...). Once done you can click on a column field item and the entire column (label and data values) will be selected. Drag these cells by their border to the desired position.

BTW, there is another approach... creating a custom sort order list... but, this list would only reside on your PC and not "travel" with the workbook which could lead to a configuration issue later. That's why I didn't mention it previously.
This message was edited by Mark W. on 2002-03-06 10:36
 
Upvote 0
Got it --- My enable button was depressed :)

My problem was i was grabbing the handlebar instead of the boundary (if that makes sense).

Thanks Again !!!!

I am interested in the custom sort - I will research it. Thanks Again !
_________________
Paul
This message was edited by Paul-Johnson on 2002-03-06 10:36
 
Upvote 0

Forum statistics

Threads
1,213,552
Messages
6,114,278
Members
448,560
Latest member
Torchwood72

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
Back
Top