This works better and in both excel and msgraph.

Apply Error bar to actual data series rather than the padding series.
Use Minus 100%. Format error bar to give skinniest line.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Andy Pope" wrote in message
...
Hi Patrick,

Sorry I was being slow making the connection, Patrick+SysMod.

How about Adding a custom Error bar to the series being used as the
padding bar.
Use a custom + value which is based on the values used for the bar. You
can then format that series to have no fill or border as well.
Only draw back is that I don't think MS graph will allow custom error bar
values.

If you still have problems drop me an email.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"SysMod" wrote in message
...
Thanks, Andy, good to hear from you.

"Andy Pope" wrote:

Maybe this will help.
http://www.andypope.info/ngs/ng43.htm

As you say
"the bar gap width is set to the maximum, in order to get a smaller
thickness as possible "

which is what I am doing .. I want them even narrower.
My current effort is at
http://www.sysmod.com/horzcol.jpg

I wonder if I tried a high-low-close chart would that do, as long as I
can
get categories on the vertical axis and the scale on the horizontal?

Thanks,

Patrick