Excel Linear Trendline Query

Hi All,

I have the below values on an excel scatter plot graph. I can draw a linear trendline through the values by right clicking on a value, hitting “Add Trendline” and hitting “Linear”. What I would prefer is to have the values of the linear trendline written on my spreadsheet as at the times of each entry. (ie fill in below “Linear Trendline Value” row).

Does anyone know if this can be done? If not, can anyone suggest an alternative method that would give approximately what I am looking for? Does anyone have any alternative suggestions?

All help will be greatly appreciated, no matter how small. Thanks in Advance for all responses.

(See attachment for Scatter Plot Graph)

Time 1 2.5 4 4.75 7.2 7.9 8.5
Value 2 5 4 3 7 4 9
Linear Trendline Value