X Y Charts - Different Label for Each Point

  • Thread starter Thread starter D. Wilkerson
  • Start date Start date
D

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.
 
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.
 
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
 
Back
Top