Plotting a custom template using VBA

**ziad9933** · 10-05-2011, 01:13 PM

Hi,

I have a template called "Ziad". The current command I am using now is

Please Login or Register  to view this content.

I tried to use this command to use the template I created but it didn't work

Please Login or Register  to view this content.

Could you please tell me what is the command I need to use to create a graph from a template?

**Andy Pope** · 10-06-2011, 04:01 AM

try using the ApplyChartTemplate rather than setting the ChartType.

**ziad9933** · 10-06-2011, 02:21 PM

can you explain more what should I write?

I am a beginner in VBA

**Andy Pope** · 10-07-2011, 03:10 AM

Did you look in the help?

Did you try recording a macro whilst applying a template to the chart?

Please Login or Register  to view this content.

Pretty difficult to provide code in context with the code you had already provided.

Re: Plotting a custom template using VBA