|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
06-16-2005, 12:05 PM
|
|||
|
|||
|
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 
|
|
#2
06-16-2005, 09:05 PM
|
|||
|
|||
|
Re: Third Party Charting Add-ons/Plug-ins/Controls
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
|
|
#3
06-17-2005, 02:05 PM
|
|||
|
|||
|
Re: Third Party Charting Add-ons/Plug-ins/Controls
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
|
|
#4
06-17-2005, 08:05 PM
|
|||
|
|||
|
Re: Third Party Charting Add-ons/Plug-ins/Controls
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 > >
|
|
#5
06-18-2005, 01:05 AM
|
|||
|
|||
|
Re: Third Party Charting Add-ons/Plug-ins/Controls
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 >> >>
|
|
#6
06-18-2005, 10:05 AM
|
|||
|
|||
|
Re: Third Party Charting Add-ons/Plug-ins/Controls
>>
>>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/ _______
|
 |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
