Creating multiple bar charts using macro and relative referencing help

G

gun_747

New Member
Joined
Mar 15, 2011
Messages
4
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

excel2.png


excel.png


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
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

A
  • Question Question
Creating a Pie Chart of a segment of a stacked bar in a Grouped Bar Chart (the bar chart I made is attached)
Replies
0
Views
323
afrailer
A
G
  • Locked
  • Question Question
Printing excel chart in high quality
Replies
1
Views
110
Peter_SSs
Peter_SSs
S
  • Solved
Hide userform title bar, and locking the userform into a relative position on the application.
2
Replies
16
Views
658
Jaafar Tribak
Jaafar Tribak
L
  • Locked
  • Question Question
How set range for chart in powerpoint created from vba
Replies
0
Views
117
Legacy 519704
L
M
  • Solved
Sort, reference and copy indeterminate cells
Replies
2
Views
143
MissT454
M

Forum statistics

Threads
1,224,518
Messages
6,179,259
Members
452,901
Latest member
LisaGo

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top