How can i find specific values along a trendline?

B

babysweet

I've entered my data, I've created my chart, I've had Excel insert a
trendline (or linear smooth line as they call it). Now what I need is to be
able to point my curser alone the line and view the value for that particular
point. Even to have it give me the value for each month along the x axis...
 
T

Tushar Mehta

XL doesn't provide any way of pointing to a location on a line and
getting the (interpolated?) value.

If you want this information in a worksheet you are probably better off
using the LINEST function.

If you want to just see the results on a chart and can live with (a)
piece-wise linear interploation and (b) entering the x/y value by hand,
see the add-in:
Interactive Chart
http://www.tushar-
mehta.com/excel/software/interactive_chart_display/index.html


--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trendline Not Appearing In Chart Problem ? 0
Trendlines: When They Will Be Generated, And When They Will Not BeFor A Scatter Chart 0
Trendline Showing Problem ? 3
How do I stop trendline from touching the y-axis? 7
How would I attach or assign values to a trendline? 4
logarithmic trendlines using zero values 2
Logarithmic Trendline 2
Get value equal to final point of chart trendline [=Trend( )] ? 1

Top