E
Excel 009
I have the following data and want to create a scatter chart. I am
using either 2003 or 2007.
Person X1 X2
a 2 4
b 8 2
c 9 3
d 1 5
e 8.5 1
(The range is =Sheet1!$A$1:$C$6)
I want to put the values (a, b, c, d, e) from the Person column next
to the data point. For example, d for the (1,5). The objective is to
put the a, b, c on the data point.
In my last attempt, I set up the series value for X in an
unconventional way – I included the Person column in it - "=Sheet1!$A
$2:$B$6"
But the problem is that X value becomes (a, 2), (b,8).
Can anyone help?
Excel 009
using either 2003 or 2007.
Person X1 X2
a 2 4
b 8 2
c 9 3
d 1 5
e 8.5 1
(The range is =Sheet1!$A$1:$C$6)
I want to put the values (a, b, c, d, e) from the Person column next
to the data point. For example, d for the (1,5). The objective is to
put the a, b, c on the data point.
In my last attempt, I set up the series value for X in an
unconventional way – I included the Person column in it - "=Sheet1!$A
$2:$B$6"
But the problem is that X value becomes (a, 2), (b,8).
Can anyone help?
Excel 009