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