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

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

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" wrote:

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

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


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

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