+ Reply to Thread
Results 1 to 3 of 3

Change categorie positions in pivot chart

  1. 03-15-2017, 10:18 AM #1
    jonas-martens
    jonas-martens is offline
    Forum Contributor
    Join Date
    02-13-2017
    Location
    Belgium
    MS-Off Ver
    O365
    Posts
    105

    Change categorie positions in pivot chart

    All,

    See file attached.
    I have a pivot bar chart witch ex 10 categories.
    Can i change the order of the categories?

    What I mean: categorie C at the bottom of the bar, categorie D above that ... ...
    Now it places it in alphabetic order, can i manually change it?

    Thx in advance
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-15-2017, 10:27 AM #2
    xlnitwit
    xlnitwit is offline
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Change categorie positions in pivot chart

    Hi,

    You can simply drag the column headers in the pivot table into the order you want and the chart will adjust to match.
    Don
    Please remember to mark your thread 'Solved' when appropriate.
    Reply With QuoteRegister To Reply
  3. 03-15-2017, 10:28 AM #3
    jonas-martens
    jonas-martens is offline
    Forum Contributor
    Join Date
    02-13-2017
    Location
    Belgium
    MS-Off Ver
    O365
    Posts
    105

    Re: Change categorie positions in pivot chart

    Wow, didn't realise it was that easy
    Thanx man!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. how to change pivot chart without affecting pivot table
    By stephme55 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-07-2016, 12:50 PM
  2. How to use SUM on cells that change positions?
    By loccy in forum Excel General
    Replies: 3
    Last Post: 02-15-2016, 09:37 PM
  3. Chart value label positions
    By stackhat in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-31-2012, 04:54 AM
  4. [SOLVED] Excel 2007 : Is it possible to change source data in pivot table and pivot chart wizard??
    By questionguy in forum Excel General
    Replies: 2
    Last Post: 04-16-2012, 05:06 PM
  5. Change positions of cells in selected area
    By MFranzen in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-08-2009, 12:59 PM
  6. How to change POSITIONS?
    By JDMiller in forum Excel General
    Replies: 3
    Last Post: 08-05-2008, 06:22 AM
  7. [SOLVED] Edit datalabel positions in a protected chart
    By Joy in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-13-2005, 04:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1