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

.ChartType = xlXYScatterSmoothNoMarkers

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

.ChartType = xlXYZiad

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?

    ActiveChart.ApplyChartTemplate ( _
        "C:\Users\xxx\AppData\Roaming\Microsoft\Templates\Charts\RS_Main_5.crtx" _
        )

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

Thread: Plotting a custom template using VBA