X Y Charts - Different Label for Each Point

[D. Wilkerson]

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.

 

[David Biddulph]

If you don't want to format each point separately, your best bet is to put
each point in as a separate series. I don't think that the wizard will do
this easily for you, so you'll need to add them a series at a time.

 

[Herbert Seidenberg]

Excel 2007
Change each point marker name, style, size, color and outline
with macro.
http://c0444202.cdn.cloudfiles.rackspacecloud.com/10_31_09a.xlsm

 

[Jon Peltier]

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