Excel graphs and VBA


Posted by Farhan on February 01, 2002 2:56 PM

I have created an application in VBA that displays VBA forms, and does not show Excel spreadsheets at the back. The user can enter data on VBA forms, that goes into the spreadsheets at the back, runs various algorithms, and spits out results, that are displayed on an output VBA form.

My question is, how do I display the outputs on a VBA form if I want to display results graphically (bar-graphs). What VB control do I use on my form to display graphs? The base application that I am using is MS Excel.

- Farhan



Posted by Ivan F Moala on February 02, 2002 4:16 AM

If you have a look @
http://www.BMSLtd.co.uk
You may find some useful hints on Charts

Ivan