View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
D. Wilkerson D. Wilkerson is offline
external usenet poster
 
Posts: 1
Default X Y Charts - Different Label for Each Point

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.