Third Party Charting Add-ons/Plug-ins/Controls

  • Thread starter Thread starter Hans Wolf
  • Start date Start date
H

Hans Wolf

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/
_______
 
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/
_______
 
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).
Click to expand...

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
 
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?
Click to expand...

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