Macro to create a chart using custom template on the data I current select

Want to select A18:A23 and then C18:C23 until BJ18:BJ23 then insert chart all charts template 360 template using a macro that just uses the current selection. All my macros keep the last selection I made the macro with.

So A18:A23 with all the following columns.

Sample attached. Thank you in advance.

Hi
try this
you will need to insert the name and path of your template in the area in red
it will create a chart for each set of rows 19 to 23 until the cell in row 18 is blank

Please Login or Register  to view this content.