Hi,

Could someone please provide guidance on the following. I would like to create a macro that essentially chooses Insert > Charts > Templates > and chooses a certain template > OK and insert the chart on the same sheet.

I want this to be relative so that it will automatically run based on whatever cells I have selected.

Thank you so much!