How to define tab location in Xl workbook for an Xl Chart

Feb 17 2007 11:26 AM
I am trying to position an xl chart object to the RIGHT of an already existing worksheet . The line of code is attached below. The the chart is always placed to the LEFT of my worksheet. Any ideas?

Thanks,
Mikhail

xlChart = (Excel.Chart)dataWorkbook.Charts.Add(System.Reflection.Missing.Value, dataWorkbook.ActiveSheet, 1, System.Reflection.Missing.Value);