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
Set osheet = oBook.Worksheets.Item(1)
oXL.Visible = True
oXL.UserControl = True
Set oChart = osheet.ChartObjects.Add(50, 40, 300, 200).Chart
oChart.ChartType = xlXYScatterSmooth
oChart.SeriesCollection.NewSeries
Using Microsoft help and also some code people have posted here.
I think this code allows to manage in a better way the chart.
Anyway I'm not an expert, just trying to help.
