Is it possible to grab data from a graph (not table)?

[VorLag]

It would be super neat if this was possible, but I'm not at all sure how to even do it (if it IS possible). I used a handful of formulas to create a table so that I could create a normal distribution (an XY scatter plot with smooth lines). So, now I have my bell curve and it'd be really neat if I was able to use a very simple calculator-type tool.

Specifically, I'd want to have excel return a Y value when an X is given. I can't use a simple linear equation because this is a bell curve. I don't know if it's possible to actually reference the graph itself or something, which is more aligned with what I'd LIKE to do.

So, if an X value is entered in A1 and I want the Y value to appear in B1, how would I go about doing that?
Does anyone know if this is possible?

 

[Daveydoodles]

Would it be possible to reference your table rather than the graph?

You could have the formula lookup the x value in A1 and return the corresponding Y value in B1

 

[Daveydoodles]

should probably have read that you specifically said "not table"...

 

[VorLag]

Haha, yeah, I can't reference the table because the data is too specific. I would basically need to make this workbook a million times bigger to calculate each price's probability in order to use the table. How I have it set up, I might have prices at like:

$80
$90
$100
$110
$120

But, if someone wanted to know the Y position of say $102.50, my table wouldn't have that. If I mouse over the graph, I can see the Y value for that particular data point, but I don't know how I might be able to grab that number and display it or use it.

 

[Stiuart_W]

You need to determine what distribution your data is. Once you have done that you can establish the equation and then it is easy enough to do what you want.

So if the data is Normal you need to calculate the Standard Deviation and the mean and then the formula is standard (Google is your friend)

Regards

 

[Jon Peltier]

Use this worksheet formula:

=NORMDIST(X,mean,stdev)

where X is the value you want Y for, while mean and stdev are the mean and standard deviation of the normal distribution.

You should have used something like this to create the data to plot the distribution.