what im trying to do is create a macro that will automatically create a new chart from new data what has been imported.
the new data is basic would be just 5 numbers these number would be going into a bar graph.

in this chart is given a question number and the number of responses under each response(1,2,3,4,5)

what i want it to do is if new questions are added i want a new graph to show up on a different worksheet.

if anyone has an idea where to start that would be great.

this is a sample im working from.

if data is imported into responses it will populate counted responses and data, sheets. what im trying to do is have if more info is imported it will create a bar graph on a new worksheet from the info on counted responses.


Attachment 171221