+ Reply to Thread
Results 1 to 2 of 2

Pivot Column Headers in wrong order?

  1. #1
    Registered User
    Join Date
    05-13-2019
    Location
    Manchester, England
    MS-Off Ver
    Office 365
    Posts
    1

    Pivot Column Headers in wrong order?

    Hi all,

    I've made a pivot table that should sort the columns by year. However, the years are not appearing in chronological order.
    Can anyone suggest the changes I need to make to either the data or the pivot to get this right?

    forum.JPG





    The data it pulls from only has the years in it - entered as a number - so excel shouldn't be recognising it as a date.

    forum2.JPG

    I feel like this is a really basic fix, but can't work it out, and am clearly not using the correct key words for google!
    Many thanks in advance

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    7,306

    Re: Pivot Column Headers in wrong order?

    Have you tried just adding a sort to the year field using the dropdown?
    Rory

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. lock column headers in pivot
    By bjbboats in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-13-2016, 11:58 AM
  2. Pivot Table Data to Column Headers
    By danielex in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-05-2015, 02:39 PM
  3. [SOLVED] Need formula to return value from table based on varying order of column headers
    By ncpcpa in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-13-2015, 02:44 PM
  4. Replies: 1
    Last Post: 11-03-2013, 06:18 PM
  5. Pivot table not pulling column headers
    By joyhampton in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-18-2013, 11:21 PM
  6. pivot table column headers
    By jrtaylor in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-11-2009, 09:23 AM
  7. Column Headers in my Excel sheet are in reverse order-reg
    By vnktroa@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-22-2006, 03:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1