Pivot Table Question
Pivot Table Question
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Pivot Table Question

  1. #1
    Guest

    Default

     
    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

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com