+ Reply to Thread
Results 1 to 2 of 2

Pivot table chart, grouping several categories under specific regions, from highest to low

  1. #1
    Registered User
    Join Date
    12-07-2012
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2010
    Posts
    1

    Pivot table chart, grouping several categories under specific regions, from highest to low

    Does anyone know how to group several categories under specific regions, from highest to lowest, per region. Please see my attached chart for a better understanding of what I am trying to accomplish.

    chart example.jpg

    Thank you.

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Pivot table chart, grouping several categories under specific regions, from highest to

    Hi Chris,


    Welcome to the forum.

    You can sort the data using sort or re-arrange may be using some formula (large /small function ) and then you can easily plot them on chart. thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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