+ Reply to Thread
Results 1 to 3 of 3

Resorting order of whisker plots

  1. #1
    Registered User
    Join Date
    05-08-2020
    Location
    Pennsylvania, USA
    MS-Off Ver
    2016
    Posts
    35

    Resorting order of whisker plots

    With traditional plots, you can use the 'Select Data' box to reorder the series, but those up and down arrows are greyed out in Box and Whisker plots. Is there a way to do this that doesn't require actually resorting the original data? I've searched documentation everywhere and can't find anything to help.
    Last edited by scavia; 06-13-2020 at 06:33 PM.

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,883

    Re: Resorting order of whisker plots

    If it's constructed using new Box & Whisker plot template. I don't think you can.

    You could always manually add/remove Serires entry (along with range reference) in Select Data Source menu to change ordering. But it's also very manual.

    In below image. I first removed "B" series and then added it back to change order from A to C, to A, C, B.

    0.JPG
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  3. #3
    Registered User
    Join Date
    05-08-2020
    Location
    Pennsylvania, USA
    MS-Off Ver
    2016
    Posts
    35

    Re: Resorting order of whisker plots

    Thanks. Adding Box & Whisker option was a great addition, but it sure is inflexible compared to the other plot options

+ 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. Three pairs of box whisker plots in one coordinate system
    By excelactuary in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 11-09-2013, 03:56 AM
  2. Box-and-whisker chart (box plots)
    By James in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-07-2011, 01:01 PM
  3. Box-and-whisker plots error
    By raychel_87 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-28-2008, 02:49 PM
  4. box and whisker plots
    By Les Clifford in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-18-2008, 01:09 PM
  5. [SOLVED] Resorting full names
    By Jim Sigurdson in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-02-2006, 06:10 PM
  6. [SOLVED] how do I create box and whisker plots in Excel?
    By Gary Greeno in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-10-2005, 03:30 AM
  7. [SOLVED] Excel gives me line plots - I want scatter plots
    By Pangloss in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-14-2005, 10:05 AM
  8. [SOLVED] Resorting Data- Help!!
    By eide0084 in forum Excel General
    Replies: 1
    Last Post: 08-12-2005, 04: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