Don't use apply custom type. The custom types are inflexible.
Make your chart using a single type, then one by one change the type of each series you want to change. Also change the axis group to secondary if desired. It seems like more work than using a custom type, but if you think about it, it's been more work to use the custom template, because the custom template doesn't do what you want. Since you're using VBA anyway, after you do the initial code, it takes no longer to use.
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions