2 Replies Latest reply on Jul 21, 2017 1:49 PM by shwetha sarma

    Help with Box and Whisker.

    shwetha sarma



      I'm trying to create a worksheet with box and whisker. I'm working with a lot of data. But, box and whisker is the perfect visual for me as I want to see the highs and lows and the average as well.


      But, since there is a lot of data, box and whisker looks very crowded and shows a bunch of dots.


      So here's what I want. I want the box and whisker not to show anything initially. I want to see the data only when I drill down. I hope this makes sense and it is easy to do.


      Here, I'm using Sample Superstore data. I used Sub-category and Sales. I want to start off blank initially and once I filter onto each sub-category I want to be able to see the value so it looks neat.