I have three columns of data. The data in column A is manager's names, column B is areas of business, column C is the data. There are roughly ten managers and three areas of business. The managers can have one to all three areas of business. A partial mock-up of the table is as follows:

Joe IT 19872
Joe Sales 98700
Joe Admin 32498
Bill IT 323
Bill Admin 3242
Sam IT 3241
Pat Sales 23413
Pat Admin 43214

I want a bar chart that will use columns A and B as the category (Y) axis and column C as the value (X) axis.

I can create the chart correctly except for one thing, it always puts the manager's names perpendicular to the business names. So the managers are vertical and the businesses are horizontal. The result is that the manager's names form one long vertical clump whereas the business names are easy to read.

How can I get both to be horizontal or to do something that will make it readable? I've tried everything that I can think of including making the font smaller and changing the alignment but that doesn't help. Nothing seems to affect the column A labels.

Thank you.