Thank you Hilmar,
Your article gave the solution I was looking for. It is the Location method of the chart object.
Thank you ver much.
Luis
>My article on Excel Automation includes a simple example:
http://www.utmag.com/September2002/Page45.asp>
>HTH,
>
>Hilmar.
>
>>Hi friend!
>>
>>I'm using Excel OLE automation to create a chart whose data source is in a worksheet. I need to create a chart in the same sheet as the data is. How can I do it? I used the Add() method of the charts class but it creates a new chart as a new sheet, I don't want that. I want to have the chart incrusted in a sheet.
>>
>>Any hepl would be very appreciated.
>>
>>TIA
>>
>>Luis Guerra