Hi. I want to help about the very first posts. I didn't take the time to review all comments so maybe the problem is already solved.
To change the chart type in Excel I used the next code:
Set oXL = CreateObject("Excel.application")
DoCmd.SetWarnings False
Set oBook = oXL.Workbooks.Add...