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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Charts 1
Calling ApplyCustomType for Excel 2002 in C# 2
Setting size 3
Applying custom chart type 1
Changing Input to code that creates a chart 2
Chart syntax 4
Macro to create chart 2
Delete a chart 4

Back
Top