Anything you don't like, double click on it. This allows you to define a
different thickness (or color) for the high-low lines (Patterns tab),
and change the width of the cyan bars (Gap Width on the Options tab).


Gap width? Okay, I'll try it, thank you.

See, I tried many things with the regular Excell charts. Are there any
third party charting components?

But you didn't try gap width or high-low line thickness. These are built
in properties of Excel's chart elements.

There are third party add-ins that make it easier to use Excel's built
in chart properties (see Rob Bovey's Chart Labeler, for example, a free
download from http://appspro.com).

You could use a third party program like Harvard Graphics, Sigma Plot,
Delta Plot. I have no direct knowledge of any of these. I believe they
all accept Excel input files, but I don't believe they can be controlled
via VBA.

You can also use many of the third party graphing packages built as
components to drop into a VB or .Net project. These have names like
Chartfx, Dundas Charts, DotNet Charts, etc. I have no experience with
any of these. I know they make "pretty" charts, but I don't know whether
they are as flexible as Excel charts.

Or you could visit a few web sites that have examples of Excel charting
techniques that aren't well documented:

http://peltiertech.com/Excel/chartlinks.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______