How do I decrease the gap width of the Up/down bar?

[Xcel08]

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

 

[Jon Peltier]

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

 

[Xcel08]

Thanks Jon the ideal size for me is about 300 to 400, which turn out to be
smaller when I increase the number. I thought it was another way
round...anyway thanks again.

 

[Jon Peltier]

It's the width of the gap you are specifying, where 100 = the width of the
bars. The value you specify must be between 0 and 500.

- Jon