On Fri, 17 Jun 2005 18:28:27 -0400, Jon Peltier
wrote:

Hi Hans -

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?

Long time ago I used WordPerfect's charting and found it somewhat
better than Excel's -- the thing is a cannot use these from VB :(

Hans

You can change the gridlines, too. I like to use a light gray for these
so they don't overpower the data.

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


Hans Wolf wrote:
Jon,

I need to draw a run chart diagram nicer than it looks in a regular
Excel chart:
http://www.angelfire.com/va3/brockbank/sample1.gif

to make the cian-colored bar more narrow, perhaps make the line
linking the upper and lower level lines thicker.

In other words, I want to make this kond of chart sexier.


Hans


On Thu, 16 Jun 2005 19:09:11 -0400, Jon Peltier
wrote:


Hans -

What is it you are trying to accomplish? The capabilities of Excel
charting are broader than most people imagine.

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


Hans Wolf wrote:


Can somebody suggest any third party Charting
Add-ons/Plug-ins/Controls that expand the charting capabilities of MS
Excel?

Such that may be code-controlled in VB or VBA.

Hans