Excel 2007 : Need More than one Data Set added to X-AXIS(Horizontal) in my Bar Graph/Chart

[sethwb]

I need help with a bar graph/chart. I have the chart almost complete I just need to add another set of data on the horizontal axis that is identical to the one already in it... I'd learn it myself but googling really doesn't help since the terminology for this stuff is so damn similar for everything.

Example of data:


Question 1 Reponse Percent
Yes 96%
No 4%
Question 2
Yes 95%
No 5%
Question 3
Yes 90%
No 10%


My problem is that I can't get the bar graph/chart to add Question 2 and 3 to the horizontal Axis. I have the bar graph/chart exactly the way I want it to look for Question 1 though.

I attached a copy of the excel file and the chart is open and ready to go.

Thanks in advance for advice.

[Andy Pope]

The key is your data layout, which is not obvious from your post.

The outer category labels should be in the first column, inner category labels in second column and data in third column

[sethwb]

Thanks Andy,

Assuming the question is a long sentence - how can I get it to wrap or turn it horizontal? My current questions on the left side run the entire height of the graph making it hard to tell which question belongs to which set of data...

[Andy Pope]

You can not control the text alignemnt of the outer labels.

You maybe able to adapt this textbox approach

http://www.andypope.info/vba/Axislabel_textboxes.htm

Or use cells for the outer labels and manually align the chart to look correct