Creating multiple bar charts using macro and relative referencing help

[gun_747]

Hi all,

I was able to sort out my own sort macro, by using relative referencing and recording a macro. My problem is I cannot do this for creating a bar chart for each question. I have submitted screen shots of the data and the chart I need (its the same type each time) but the macro will not work. Can someone advise me please

I tried using the record macro command with relative referencing. I want the title of the chart to be the question that is being asked with no series included. Can someone please help me

 

[gun_747]

anyone any ideas please