User defined chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top