I am trying to create an Excel Chart using Visual Basic. My problem is that the chart type does not appear as i have set it. The way I am trying to do this is as follows:
xlApp.ActiveChart.ApplyCustomType ChartType:=xlBuiltIn, TypeName:="Line - Column"
<snip rest of code>
When the chart appears, it is always the default Chart (columns) not the built in type that i have specified above.
Does anyone have any ideas on how to fix this?