Hi, I've searched the net high and low, tried slope and trend suggestions but no success, please help?! On my chart I have an automatic Linear trendline, however if I hover over any point there are no data value for the most up to date end point as is relevent to the x,y values of the rest of the chart. So I figured that this value would be imposible to obtain from the chart itself as I need the end value to automatically calculate into a cell. So given the x and y range the rest of the chart is built from, I need somehow via formula to calculate the linear line from A2:A1000 and D2:D1000 and then somehow determine not only the value of that current end point is but how to get the formula to interpet where and what that is on the y - D column value as it is presented on the chart as a reading? 
