Hello everyone,
This question is more about math then a chart one but it uses data from chart
In the given chart (Screenshot 1) i have x values in log (screenshot 2 black numbers) and y values (screenshot 2 red numbers). Given numbers form a curve on the chart.
I'm required to find the value where the green lines intersects the blue dotted lines on the chart (top row x values, 0.002, 0.0063, 0.02, 0.2 etc)
example, the value at blue dotted line 0,0063 is 87 (reading from the left) or 13 reading from the right)
I would like to create a formula on that will calculate the value at intersections of the green data line and blue chart line
Example, using values from screenshot 2: 0.09 - 96.17416 and 0.25-98.59551 to calculate the value at 0.2 point (blue doted line)
Function forecast linear and even forecast won't work on this one
Thanks in advance.
screenshot 1
Screenshot_2.jpg
screenshot 2
Screenshot_3.jpg
Bookmarks