Change Event labels on Chart

How can I change where the lines are drawn down to. I want the lines to go to the blue line not the pink one. I got this off a cool site recently and playing with it.

Found out a few nice tricks but cant figure this one out. Just want to change where the lines go to. See chart 2

Hi,

the data for your label points comes from a VLookup on the Trend Data, which is the pink data series.
That's why the line of the label points to the pink data series.

The blue data series is an externally linked sheet. In your table on Sheet International Events, you need to change the formula to lookup the data points from the same source that the blue series takes its data from.

Or, you could forget about the lookup and enter the value manually. For example, if you enter 66% for the value for Note1, it will draw the black line down to the blue data series.

'zat help?