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

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
<jonREMOVExlmvp@peltierCAPStech.com> 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
> <jonREMOVExlmvp@peltierCAPStech.com> 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
<jonREMOVExlmvp@peltierCAPStech.com> 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
>> <jonREMOVExlmvp@peltierCAPStech.com> 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/
_______