+ Reply to Thread
Results 1 to 5 of 5

Sort Order of Pivot Table and Vertical Axis of Pivot Chart are not the Same

  1. #1
    Forum Contributor
    Join Date
    04-01-2019
    Location
    USA Ohio, Fremont
    MS-Off Ver
    Office 365
    Posts
    128

    Sort Order of Pivot Table and Vertical Axis of Pivot Chart are not the Same

    I have created a Pivot Table from my Microsoft Excel Worksheet Table. From this Pivot Table I have created a Pivot Chart.

    The table and chart I created are shown on the attached PDF file.

    The problem I am having is I would like the sort order for the Row Labels on the Pivot Table to match the sort order for the Pivot Chart Clustered Bar Chart Vertical Axis.

    Current Sort Order

    Row Label Sort - Blank, 10 thru 9
    Chart Vertical Axis ? 9 thru 10, Blank

    This sort order is the complete opposite of each other.

    The Table and Chart are linked together and if I try and change the order on Row Label Sort it changes the sort order of the Chart Vertical Axis.

    How can I make the two sort orders the same?

    I would like the sort order to be the same as the current sort order the Row Label Sort.

    This has been really frustrating trying to figure out how to this !!!!.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Sort Order of Pivot Table and Vertical Axis of Pivot Chart are not the Same

    This is an Excel forum... it might be better to upload an Excel file that we can play with... not a pdf that we can only look at.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Sort Order of Pivot Table and Vertical Axis of Pivot Chart are not the Same

    with bar charts the category items start at the bottom and build up.

    Format vertical axis to be in reverse order.
    Additional set the Horizontal axis Crosses At, to maximum, which will reposition the value axis at the bottom
    Cheers
    Andy
    www.andypope.info

  4. #4
    Forum Contributor
    Join Date
    04-01-2019
    Location
    USA Ohio, Fremont
    MS-Off Ver
    Office 365
    Posts
    128

    Re: Sort Order of Pivot Table and Vertical Axis of Pivot Chart are not the Same

    Thank You!! Andy Pope your suggestion did the job. I appreciate your help.

  5. #5
    Forum Contributor
    Join Date
    04-01-2019
    Location
    USA Ohio, Fremont
    MS-Off Ver
    Office 365
    Posts
    128

    Re: Sort Order of Pivot Table and Vertical Axis of Pivot Chart are not the Same

    In most cases I do upload a file. I didn't in this case because it contained a lot of employee information, and I was hoping my PDF file would provide sufficient information for a recommendation.

    Thanks for looking at the PDF file.

+ 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. [SOLVED] Pivot chart X axis labels not aligned to the corresponding vertical bars
    By Jigneshbharati in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-12-2021, 02:19 PM
  2. [SOLVED] Vertical Axis in Pivot Line Chart Is not Tally
    By ulala2 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-02-2019, 12:10 AM
  3. [SOLVED] filtering a pivot chart / pivot table on x-axis values
    By Trebor777 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-20-2016, 01:28 PM
  4. Sort data table legend in reverse order of vertical axis
    By Robertjb1 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-01-2011, 11:13 AM
  5. Excel 2007 : Pivot Table Sort Order
    By paulrockliffe in forum Excel General
    Replies: 1
    Last Post: 03-30-2010, 12:46 PM
  6. Pivot table sort order
    By Vincdc in forum Excel General
    Replies: 2
    Last Post: 03-01-2006, 01:25 PM
  7. Replies: 0
    Last Post: 07-13-2005, 05:05 PM

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