Excel 2007 'line- column on 2 axis' chart

[surfengine]

Just switched to 2007 and my macro for creating a chart fails.
Does anyone know the name in 2007 for this chart type?

    ActiveChart.ApplyCustomType ChartType:=xlBuiltIn, TypeName:= _
        "Line - Column on 2 Axes"

[teylyn]

Hi surfengine,

Excel 2007 does not have a template for that chart type anymore. There's a discussion about exactly this problem going on here.

http://social.msdn.microsoft.com/for...-8008f0ef2739/

About halfway down the thread they're getting to a solution. Hope you can follow it.

[surfengine]

thanks, that appears to be working.

just one issue with my workbook, but I guess ill figure that out.