excel automation - add chart

I have managed to create a chart inside a worksheet. What I would really like is to place the data in one worksheet and the chart in another. My first posting here, let me know if I should have done anything different. Thanks

Ulvaer, You can write data to first a worksheet. Then add a chart control and give it the range appropriately from above worksheet.You can make use of Excel Chartwizard for the same. Regards, Rajesh