This content has been marked as final. Show 2 replies
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.