Greetings
I am trying to get VBA to use a chart template instead of the 3DPie it is currently using. I am also wanting it to reference source data on the active worksheet instead of coding it as part of the macro.

Right now, this is what I have been able to cobble together but I am having to manually change the chart type and the source range.


    Range("AA13:AB15").Select
        ActiveSheet.Shapes.AddChart.Select
        ActiveChart.ChartType = xl3DPie
        ActiveChart.SetSourceData Source:=Range("'On Your Six 032212'!$AA$13:$AB$15")
Any help would be greatly appreciated.

Thanks