Creating Leader Lines on a Chart

[Nelson B.]

I have a graph that contains a scatter plot of data points, with an adjusted
trend line running through the points. I'm looking to create leader lines
that go from each data point to the corresponding point on the trend line
that is above/below it. Any suggestions? Thanks!

Sample Data:

data trend
200.0 200.0
199.0 199.9
205.0 200.4
198.0 200.2
197.0 199.9
200.0 199.9
195.0 199.4
194.0 198.8
194.0 198.4
197.0 198.2
196.0 198.0
200.0 198.2
192.0 197.6
193.0 197.1
192.0 196.6
195.0 196.4
194.0 196.2
191.0 195.7
194.0 195.5
192.0 195.2
190.0 194.6
192.0 194.4
192.0 194.1
195.0 194.2
191.0 193.9
192.0 193.7
190.0 193.3
192.0 193.2
193.0 193.2
191.0 193.0
190.0 192.7

 

[Luke M]

Create another column of data, formula is
=A2-B2
copy down.

Now, select your data series, format, go to y-error bar. Under negative
custom amount, put a range reference to the values you just created. hit ok.

To get rid of the crossbar, double click one of the error bar. Go to pattern
tab, and change the marker to have no crossbar.

 

[Nelson B.]

This worked- Thanks Luke!

Create another column of data, formula is
=A2-B2
copy down.

Now, select your data series, format, go to y-error bar. Under negative
custom amount, put a range reference to the values you just created. hit ok.

To get rid of the crossbar, double click one of the error bar. Go to pattern
tab, and change the marker to have no crossbar.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*