User defined chart

i am writing a macro that creates charts. I want to use a user defined chart
type (that I have) but I dont know how to write the code for this. My code is:

Charts.Add
With ActiveChart
..ApplyCustomType(xluserDefined, Standard)
..............
End with

As you may see the third line is wrong. How should you write this? Please
help me!

Freddie,

Try this:

Set ch = Charts.Add
ch.ApplyCustomType ChartType:=xlUserDefined, TypeName:="Mikes"

And replace Mikes with the name of your custom chart.

Mike

"Freddie Mac" wrote:

> i am writing a macro that creates charts. I want to use a user defined chart
> type (that I have) but I dont know how to write the code for this. My code is:
>
> Charts.Add
> With ActiveChart
> .ApplyCustomType(xluserDefined, Standard)
> .............
> End with
>
> As you may see the third line is wrong. How should you write this? Please
> help me!