How to populate Excel Chart using recordset?

[MikeBronner]

How can I populate an Excel Chart in my VB App using a recordset? Will I have to use a shaped recordset or can I use a "flat" one?

The only chart I have used so far is MSChart, which came with VB6 and doesn't have the functionality that I require.
So needles to say, please bear with me, I'm limited in my chart-experience. ;->

Thanks,
Mike Take Care,
Mike

 

[MikeBronner]

Or perhaps with ChartSpace controls? It doesn't have to be necessarily the Excel Chart control.

Thanks,
Mike Take Care,
Mike

 

[MikeCox]

When you say Excel Chart, is that the same thing as an Excel Spreadsheet? If you want to populate an Excel Spreadsheet from an Ado Recordset, I found some code on

http://www.vb2themax.com

that will help you. Of course, this code will require your users have Excel installed, but hopefully that's what you're looking for.

-Mike Difference between a madman and a genius:
A madman uses his genius destructively,
A genius uses his madness constructively.

 

[MikeBronner]

No, not the excel spreadsheet. This is purely a chart control in VB (look for MS Excel Chart in the components selection window).

Thanks,
Mike ;-> Take Care,
Mike

 

[MichaelRed]

Michael,

the "chart" control in VB/Access/Excel/Word .... is the same object. It is what Ms. refers to as an "applet". If you learn how to manipulate it programatically, it uses/accepts the same methods and properties. The ASSUMPTION is just that if you are using Excel (or Word) you are not a programmer, so you will need the screen controls to manipulate the objects, but that VB/Access/C++ ... are programming languages, therefore the user must be a programmer, hence the manipulation is via CODE

I wrote a brief 'test' module in Ms. Access a few years ago to 'demo' to a group the various methods & properties which could be set via code. Can't quite seem to locate it at the moment (casualty of movong machinery?). But if it would help, I will at least give the assemnbled media one more scan on your behalf.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over

 

[MikeBronner]

Thanks guys!

I've been scouring the net for the past few days now in search of some documentation on how to manipulate the darn thing, but haven't seem to be able to find anything.

Mike Take Care,
Mike

 

[MikeBronner]

Does anyone have any resources or advice on how to populate these charts? I have no idea where to start... perhaps an example?

Thanks! ;-) Take Care,
Mike