If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Creating Leader Lines on a Chart
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 |
#2
|
|||
|
|||
Creating Leader Lines on a Chart
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!* "Nelson B." wrote: 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 |
#3
|
|||
|
|||
Creating Leader Lines on a Chart
This worked- Thanks Luke!
"Luke M" wrote: 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!* "Nelson B." wrote: 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 |
Thread Tools | |
Display Modes | |
|
|