Points in between Data Series
 

I'm using an xy scatter chart, to do grain size analysis, what I need to
know is how do I find out the value in between data points, for example I
would like to know the value of where my data series line crosses at 60% what
is my x value.

I apologize for any confusion, I'm not sure how to properly ask this
question.

D

Points in between Data Series
 

This isn't the kind of thing that Excel has built into it, but it
certainly is capable of the calculations necessary. Do you just have a
table of data or do you have an analytic function [y=f(x)] for the grain
size that you could use to calculate x at y=.6?

If you have the function, then it would be easy enough to solve the
equation for y=.6 either analytically or numerically (using Solver/Goal
seek).

If you don't have the function, you could curve fit the tabulated data
to a reasonable function and then use that to estimate x at y=0.6.

You could also use an interpolation routine (linear interpolation is by
far the easiest to implement) to estimate x at y=0.6. Excel doesn't
have a built in interpolation routine, but you could build one either
with worksheet functions or in VBA.

If all else fails, you could visually pick the value off of the chart.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=487303

Points in between Data Series
 

Hi Broken man,

If you just want linear interpolation, download 'Intercept Vertical Lines'
from http://edferrero.m6.net/charting.aspx

Ed Ferrero
http://edferrero.m6.net/

I'm using an xy scatter chart, to do grain size analysis, what I need to
know is how do I find out the value in between data points, for example I
would like to know the value of where my data series line crosses at 60%
what
is my x value.

I apologize for any confusion, I'm not sure how to properly ask this
question.

D