Rajendra_kodavaty
New Member
- Joined
- Oct 12, 2015
- Messages
- 23
Hello Folks,
I am working on a Excel sheet Which has the following data as example
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Score 1[/TD]
[TD]Score 2[/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD]5[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]XYZ[/TD]
[TD]6[/TD]
[TD]12[/TD]
[/TR]
</tbody>[/TABLE]
I would like to get the graph as with Score 1 on X axis and Score 2 on Y axis (Or vice versa) and the data label should show the name in scatter plot.
I am able to get the the two axis on the respective axis but cannot figure out how to get the name of the intersected point
Request your assistance on the same
I am working on a Excel sheet Which has the following data as example
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Score 1[/TD]
[TD]Score 2[/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD]5[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]XYZ[/TD]
[TD]6[/TD]
[TD]12[/TD]
[/TR]
</tbody>[/TABLE]
I would like to get the graph as with Score 1 on X axis and Score 2 on Y axis (Or vice versa) and the data label should show the name in scatter plot.
I am able to get the the two axis on the respective axis but cannot figure out how to get the name of the intersected point
Request your assistance on the same