Coordinate lines on Scatter Graph

[JackDanIce]

Hi,

I have the following data points:

	A	B
1	X	Y
2	0.18	0.52
3	0.5	0.73
4	0.1	0.26
5	0.19	0.38
6	0.57	0.16
7	0.73	0.88
8	0.3	0.27
9	0.25	0.44
10	0.4	0.91
11	0.6	0.93

<COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"></COLGROUP><TBODY>
</TBODY>

And can create a scatter diagram fine. However, I've been asked if it's possible to show on the graph, for each point a line to it's respective X and Y co-ordinate. For example, for row 4 (in red), on the same scatter graph, I'd like there to be two lines for this point,

Line1 drawn from (0.1, 0) to (0.1, 0.26) and
Line2 drawn from (0,0.26) to (0.1,0.26)

I know it's possible to overlap graphs in Excel, but I can't find how to achieve this with scatter plots, please assist.

Many thanks,
Jack

 

[gsistek]

This is what I would do.
Add error bars to the data points. For both the horizontal and vertical error bars, set them to display minus with no cap and set them to be 100%. This should give a horizontal and vertical line from each point to the x and y axes.

 

[JackDanIce]

That works great, thank you gsistek

 

[gsistek]

Glad I could help. Thanks for the feedback.