Values on Data Points in a Box Plot Chart

[#1]

I'd like to show the Quartile and Fractile numbers in a Box Plot chart. However, the "Values on Data Points" checkbox for a Box Plot is disable. Show a box plot without see those 5 measures is not interesting, so is It possible to do what I am trying to do?

[#2]

Any ideas?

[#3]

I'm also facing this problem. How can I add Text as Pop-up in a box plot chart? Something similar to the one below:-

[hdonald]

Hi,

Using Stephen Redmond's idea of adding an extra expression with no symbol, line or bar ticked but with 'Pop Up Labels' selected, just for providing custom pop up text, it is possible to display the box plot values.

There did seem to be some issues - the box plot had to be last in the expression list for it to work and the expression itself has to contain the formatting you might have done in the Numbers tab.

I was using a copy of the Call Centre demo to try out adding a seven figure summary so the time formatting had to go in the 'pop up text' expression as follows;

'Max - '&Interval([Max],'mm:ss')&chr(13)&

'90th Percentile - '&Interval(fractile([Answered Active Time],0.90)/24/60/60,'mm:ss')&chr(13)&

'75th Percentile - '&Interval([InterQuartile Range],'mm:ss')&chr(13)&

'Median - '&Interval((median([Answered Active Time])/24/60/60),'mm:ss')&chr(13)&

'25th Percentile - '&Interval(fractile([Answered Active Time],0.25)/24/60/60,'mm:ss')&chr(13)&

'10th Percentile - '&Interval(fractile([Answered Active Time],0.10)/24/60/60,'mm:ss')&chr(13)&

'Min - '&Interval([Min],'mm:ss')&chr(13)

Another problem was that in order to get the box plot image to trigger you need at least  3 more expressions ..one each for the top, bottom and middle of the plot ....that are set to 'symbol' and 'invisible'.

Even then, with large box areas, the hover over will need to hit one of those points to trigger the pop up so not an ideal solution.

The Call Center demo chart I copied had a fast change set to pivot and straight table which was a pretty good way alternative to switch to a number based view.

Looking at the example I'd be interested if anyone knows how to set up some kind of toggle to add/remove the 'max' value as it's squashing the box plot and some users may wish to switch that one figure off,

Regards,

HD

[#5]

I know this is an old post but I was reading it to get a pop-up with the box plot data and figured out a better way to do it. Instead of using 3 extra expressions as HD suggested, one for the top, bottom and middle as symbols I used 1 expression displayed as a bar that has:

• the data I want to show on the pop-up as the Label of the expression,
• the definition is the difference between the MAX and the MIN to get a bar the size of the whole plot for each member of the dimension (including the outliers)
  • If you want to get the pop-up only when hover over the box (no outliers) use the difference between the 75 and the 25 fractile
• The "Bar Offset" property of the expression (open the expression properties with the + on its left) set to the MIN so the bar starts where the minimum value is
  • Use the 25 fractile for pop-ups just on the box (no outliers)
• Promote the expression to be the top one
• Change the color to be transparent (it didn't work for me to get it Invisible, I didn't get the pop-up)

The result looks like this (make the bar transparent)