Creating a Bar chart with Series

Background

At work, we ran two different surveys of the public at various venues. The first survey asked people to prioritise 6 health conditions as either 'High Priority', 'Medium Priority' or 'Low Priority'. They had to put two of the six conditions into each box.

The second one asked questions about the service people received the last time they went to the doctors/hospital/dentists etc. We had six questions, to which they answered either 'Very Satisfied', 'Satisfied' or 'Not Satisfied'.

What We Did Next
I have collated the results into a spreadsheet (attached (EDIT, NOW REMOVED)). Each survey is on a different page. I have the conditions/questions along the top, with the venues down the left.

What I Need
I need to create a bar chart for each of the surveys. It should look a little like this:

http://img151.imageshack.us/img151/5492/grapho.jpg

It has each of the conditions as the categories, and then has each categories option (High, Medium or Low priority) as series. And then the same for the other survey.

When I try to do it, it puts them all as seperate categories (Smoking High, Smoking Medium, Smoking Low), when I want one category with three series.

Can anyone help?