Sorting order in Excel charts

[hypedaj]

I need help with a seemingly simple problem:

I have following data:


Sales Profit
A 100 50
B 50 100
C 75 350

How do I set up an Excel column chart where my x-axis has Sales and Profit for Companies A, B, and C and is sorted in ascending order for both Sales and Profit i.e. preserving the same order and color: i.e. in Sales, A is best (and let's say Excel '07 gives it a blue color) but is worst in Profit --I want the chart to show A as the first value in Sales and the last value in Profit with the same color scheme.

Thanks in advance for your help!