Results 1 to 3 of 3

Thread: Sort in a Pivot Chart

  1. #1

    Sort in a Pivot Chart



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Does anyone know how to sort a bar graph by descending value (actual units), will not let me sort in Pivot table because it has multilple columns (categories)

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,437
    Articles
    0
    Excel Version
    Excel 2016
    Not sure what you've tried, see this article or google for "sorting pivot chart" (without quotes):

    http://office.microsoft.com/en-ca/ex...005202971.aspx


  3. #3
    Yes I read this article as well. The problem is that I have multiple (3) categories in the vertical axis. So when I do a sort in the last column in my pivot table, it only sorts by each individual sub-category, not ALL the sub-categories combined. Does this make sense? I cannot remove this subcategory either because I need to show it in my Pivotchart. I even changed the report layot to tabular form, took out all the subtotals then sorted by largest to smalles butonce again it did not do it at the last level only at the sub catgeory level prior to it.

Posting Permissions

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