Add lines (arrows preferred) between related series of XY scatter

[AlvaroSiza]

Simple XY Scatter:

x-axis represents nth instance of home sale (From intersect of y-axis out to right; Sale No. 1, Sale No. 2, etc.)
y-axis represents Sale Price

For each x there are two y values - Sale Price and Adjusted Sale Price.

I would like to connect, hopefully via directional arrow, the sale price and adjusted sale price showing the direction of adjustment. (Downward arrow if Adjusted Sales Price is below the actual Sales Price, upward arrow if Adjusted Sales Price is above the actual Sales Price.

Here is a screenshot of what I'm after. The 1st and 2nd instance of x is how it appears now, with all others how I would like them to appear bearing in mind that red can and will often be below white.

XY w lines.png

Quoting Andy Pope from http://www.pcreview.co.uk/forums/con...-t3687181.html

If the chart is really a xy-scatter then Hi-Low lines are not available. You can mimic the lines using Custom Error bars. You need to calculate the difference between each pair of Y values and use them as the Custom Error value.

How specifically do I implement custom error bars to accomplish what I am after? I have calculated the spread between each instance of y values.

Many thanks!

AS

[Andy Pope]

With your regular X axis spacing you could use a line chart and therefore use the drop lines.

If you use the xy-scatter you add error bars and then on the format error bars dialog use the Custom button to select the range of cells to use.

Alternatively you could use a xy series to draw the arrow line.

[Andy Pope]

Edit:
Ignore the suggestion of Line chart and drop lines. This will not work as the lines always drop down.