Ha, looks like they left that out. I couldn't find it in the UI.

You can change the gap width using VBA. Select the chart, then press Alt+F11
to open the VB Editor. Press Ctrl+G if the Immediate Window isn't visible,
then type this (with the desired value where I have 100) and press Enter:

ActiveChart.ChartGroups(1).GapWidth = 100

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Xcel08" wrote in message
...
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