I want to plot a series of results into a chart as one data point. To
clarify, I have multiple rows with three colums of data. I would like each
row (column one being the Series title column) to be one data point (i.e. Row
One = Store 1, Column 1 = "Store 1", Column 2 = Sales $'s, Column 3 = Profit
%). On the chart I would like the X-Axis to be Profit % and the Y-Axis to be
Sales $'s. The example above, using typical charting functions, results in
two data points for Store 1 (the Sales $ plotted as one point and the Profit
% plotted as another point). I only want one data point where the Sales $
and Profit % meet (i.e. the way you would plot when you were learning
charts/graphs as a kid).

I have found a work around, but it requires manually setting up each Row of
data as its own series and the corresponding name, X and Y Axis variables.

It would be nice if this set-up could be done without so much manual
intervention.

I'm using Excel 2003.

Thanks in advance for any help you can offer!