Excel automation- Chart object?

Hii All,

What i want to do is to generate Excel sheet and draw chart on sheet at run time using data from VB. My app. is developed in VB.

Does anybody have done this? Any reference or example or web link? Please provide some input.

I know how to create excel object from vb and use it's properties. But i have never done work realted to chart in Excel.

Everything is welcome.

Thanks,

Himanshu Dave
draw chart

Programmatically manipulating the Excel object is not well documented - esp. on the web. Very few examples. I had to buy a book to learn anything. I suggest you do the same:

"Writing Excel Macros with VBA, Second Edition" by Ronan, an O'Reily book.

Dave