Macro Recorder doesn't record Design/Select Data

[VBAProIWish]

Hello All,

I used the macro recorder to record the following...(recorded code below)

1. Select a chart
2. Select "Design" in the ribbon
3. Select "Select Data"
4. Select my desired data range
5. Press ok
6. Insert a template

However, the only part that's recorded is selecting the chart and inserting a template.
The recorder completely ignored steps 2-5.
Does anyone know why?

   Sheets("Slide 1").Select
    ActiveSheet.ChartObjects("Chart 1").Activate
    Application.CutCopyMode = False
    ActiveChart.ApplyChartTemplate ("C:\Charts\_Slide 1.crtx")

Thanks much

 

[EFANYoutube]

Hi
Please try adding the below

ActiveSheet.ChartObjects("Chart 1").SetSourceData Source:=Sheets(1).Range("A1:A10"), PlotBy:=xlColumns

Also, its a good idea to learn how to code explicitly as the code created by the recorder can have undesired consequenses

How to Avoid the Select Method in VBA & Why - Excel Campus

The Select method in VBA can be just as time consuming for Excel, as it is for you to get up off the couch to change the channel.

www.excelcampus.com

 

[VBAProIWish]

Perfect and thank you!