Plot the points as a single series, using Distance and Weight values.
Format the series to "Vary colors by point". In 2003 it's on the Options
tab of the Format Series dialog. In 2007 I don't know where it is,
because I hadn't yet thought of varying colors by point while using 2007.

Then use Rob Bovey's Chart Labeler add-in to apply the labels in the
Item column to the points. It's free at http://appspro.com.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



D. Wilkerson wrote:
I have a similar issue to the one posted in "Why does X axis become another
data series". I want to build an X Y chart with a different label for each
of the rows/points. For example,

Item Distance Height
Red 0 5
Blue 5 4
Green 8 3

When I do an X Y Chart on this data, it gives me a point for Distance and a
second point for Height for eash "Item" (let's say a square is used as the
point marker on the chart for "Red", in this case I get two squares). I just
want 1 point at the intersection of Distance/Height, with the point format
changed for each row (square for Red, triangle for Blue, diamond for Green,
for example). Thank you.