I am using Office 2007,

OK, I need to plot a boxplot base on a 5 number summary
data.(q1,min,median,max,q3) my problem here is, how do I decrease the gap
width of the Up/down bar? In another words how do i reduce the box width if u
understand what I am trying to ask. THe older version of Excel do come with a
gap width option where you can change the width of the "box" but I can't find
it in this ver. 2007.

Thanks and appreciate your help