View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default X Y Charts - Different Label for Each Point

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.
--
David Biddulph

"D. Wilkerson" <D. wrote in message
...
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.