+ Reply to Thread
Results 1 to 2 of 2

Box and Whisker Plots - Hidden & Empty Cells

  1. #1
    Registered User
    Join Date
    09-11-2019
    Location
    Oregon, USA
    MS-Off Ver
    365
    Posts
    2

    Box and Whisker Plots - Hidden & Empty Cells

    Box and Whisker chart data source entry greys out the "Hidden and Empty Cells" dialogue. Is there a solution to this? All my data is in columns (named ranges) that are usually hidden. Thanks for any feedback.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    14,327

    Re: Box and Whisker Plots - Hidden & Empty Cells

    Have you tried building your box and whisker plot as a stacked bar/column chart instead of using the built in chart? From what I have been able to gather, the new specialty charts like the built in box and whisker diagram are convenient if you want exactly what the template calls for, but inflexible if you want something a little different (I'm assuming that hidden and empty cells is one of the inflexibilities). Usually, building the chart from one of the basic chart types allows you to regain the flexibility that the specialty chart does not have.

    If you are unsure how to build a box and whisker plot as a stacked bar/column chart, here's a tutorial: https://peltiertech.com/excel-box-an...ams-box-plots/
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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] Resorting order of whisker plots
    By scavia in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-10-2020, 09:24 AM
  2. 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
  3. [SOLVED] Box-and-whisker chart (box plots)
    By James in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-07-2011, 01:01 PM
  4. Box-and-whisker plots error
    By raychel_87 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-28-2008, 02:49 PM
  5. box and whisker plots
    By Les Clifford in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-18-2008, 01:09 PM
  6. Hidden and Empty Cells Grayed Out
    By Potatosalad2 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-09-2008, 03:45 AM
  7. 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

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