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


X

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
 
Ad

Advertisements

J

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
 
X

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.
 
J

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top