Hi - using excel 2000 unfortunately, and need to do a XY chart with labels. ie.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
></o
>
<o
></o
>
Item A x=5, y=6<o
></o
>
Item B x=3, y=4<o
></o
>
Item C x=5, y=6<o
></o
>
<o
></o
>
I need the chart to plot the points (ie. 5,6 and 3,4 and 5,6) , and show Item A, Item B etc as the data label. <o
></o
>
<o
></o
>
The two problems I have are :<o
></o
>
<o
></o
>
1. The data label shows as the x co-ordinate. ie for Item A above, the data label shows as 5, when I want it to show as Item A.<o
></o
>
2. Where there are two items the same - ie Item A and Item C, I can't get the chart to show both. Only shows the one point.<o
></o
>
<o
></o
>
Appreciate your help.<o
></o
>
MickMack
<o
Item A x=5, y=6<o
Item B x=3, y=4<o
Item C x=5, y=6<o
<o
I need the chart to plot the points (ie. 5,6 and 3,4 and 5,6) , and show Item A, Item B etc as the data label. <o
<o
The two problems I have are :<o
<o
1. The data label shows as the x co-ordinate. ie for Item A above, the data label shows as 5, when I want it to show as Item A.<o
2. Where there are two items the same - ie Item A and Item C, I can't get the chart to show both. Only shows the one point.<o
<o
Appreciate your help.<o
MickMack