Excel 2013 Chart - Macro to plot multiple rows as separate charts

[Tinfoilstar]

Hello - I need assistance please - don't know VBA at all

I have data in a worksheet that looks like this, starting in A1:

CourseTitle SD D SA SA
Question 1 2 7 34 12
Question 2 10 21 19 5
Question 3 6 13 12 24
Question 4 2 5 36 12
Question 5 3 8 25 19
Question 6 1 7 32 15
Question 7 2 8 31 14
Question 8 5 5 31 14
Question 9 1 8 27 19
Question 10 2 6 31 16
Question 11 2 7 32 14
Question 12 2 3 20 30
Question 13 1 8 36 10
Question 14 1 4 28 22
Question 15 3 4 26 22
Question 16 2 6 36 11
Question 17 2 6 25 22
Question 18 3 7 27 18
Question 19 1 1 16 37
Question 20 2 3 19 31
Question 21 2 13 24 16
Question 22 2 11 27 15
Question 23 2 16 22 15
Question 24 1 2 22 30
Question 25 2 5 34 14
Question 26 1 1 12 41
Question 27 2 1 16 36
Question 28 3 3 23 26
Question 29 1 3 23 28
Question 30 1 4 31 19
Question 31 1 6 28 20
Question 32 1 4 28 22
Question 33 1 3 21 30
Question 34 2 0 24 29
Question 35 1 5 23 26
Question 36 0 5 30 20
Question 37 1 3 24 27
Question 38 1 7 31 16
Question 39 1 6 34 14
Question 40 3 8 24 20
Question 41 1 5 30 19
Question 42 1 8 29 17
Question 43 1 8 30 16
Question 44 5 4 28 18
Question 45 6 8 24 17
Question 46 3 3 26 23
Question 47 4 5 26 20
Question 48 5 6 29 15

Range is fixed and ends in row 48.

I require a macro to draw a Bar chart for each row; Place the charts in threes on a same sheet starting in Column G with all the detail - labels, etc.
There will be multiple worksheets in one workbook. Sheet name must be taken from CourseName in A1. Chart title must be CourseName & SeriesName

Thank you kindly, in advance.

A

[dflak]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.