Swap Axes in Chart

[TheKB]

How do I change the category axis (number of items) to the value axis ($ of items)?

I'm using a bar chart and Excel 2003.

 

[VoG]

Maybe Switch X and Y (under Axes category) http://peltiertech.com/Excel/Charts/ChartIndex.html

 

[TheKB]

CORRECTION: I'm using a column chart.

Here's a representation of what I'm working with:

Cut Fell Hit Ugly Fat
Number of Items 11 20 6 14 3
$ of Items 56000 8000 40000 3000 112000


and I can't get the left side of the chart (value axis) to be the Number of Items instead of $ of Items