how to adjust bar widths on an open-high-low-close stock chart (AKA: candle chart)

I'd like to be able to to adjust bar widths on an open-high-low-close stock chart (AKA: candle chart). This is possible to do on a column chart, but I'm not able to find a way of doing it on this particular chart.

To bring this chart up, first paste the following example data into your spreadsheet and select all of it:

111.20 111.74 109.09 109.21
113.92 114.27 111.56 111.70
114.28 114.45 112.98 113.89
113.62 115.13 113.59 115.06
114.73 114.84 113.20 113.64
114.49 115.14 114.42 114.93
113.95 114.94 113.37 114.62
113.97 114.21 113.22 113.66
115.08 115.13 114.24 114.73

Then:

insert -> other charts -> all charts -> stock chart -> select second one from the left.
it should read "open-high-low-close" when you hover over it's icon.

What I'd like to do is make the bars 50% wider or so. If it is not possible to do it with standard excel commands, is there a way to program this with basic?

Thank you.

Select any of the 4 series and use the Series Option on the format dialog to adjust the widths.

Do not select the High-Low lines, Up bars or Down bar.

Here is an example with the bar gap set to 10.

Do you have xl2007 by any chance?

If so create the chart, change to clustered column, adjust series gap before reverting back to stock chart.

I suggest you update your profile to specify which Excel version you have.