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

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

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

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

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

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/
_______