How to get a value from graph

Hello folks,

I need some help getting data from a graph to display its value in a given cell. I've attached the file for reference. (using sheet titled Loading (172P)

I have a graph with multiple lines (series) depicting certain items, (.i.e, fuel, rear pax, etc.). For example, in Cell D5, I input a number and when I look to the graph, I find 190 in terms of weight, go across that line until I intersect with the Pilot & Front Pax line, then go down to see what number I need to input into Cell E5.

What I would like to do is, when I input a value, say in Cell D10, I want/need a formula that looks for that number on the graph until it intersects with the fuel line, then input that value in Cell E10. Is that even possible??

You can start by showing the intersection?

https://engineerexcel.com/2-ways-to-...scatter-chart/

Article covers both Scatter AND line charts.

Hope it helps

Ochimus

Originally Posted by MrShorty

They look like basic straight lines, so you can use whatever strategy you like to get at the information from those lines. The chart won't do this, but you will use the data in the spreadsheet. I would probably use the TREND() function for these (https://support.microsoft.com/en-us/...3-9a7cf7b51ef1 ), though the FORECAST() function will also work.

To get moment from pilot/pax weight =TREND($AR$4:$AR$5,$AS$4:$AS$5,D5) Same for the fuel line (adjust references to AT and AU, accordingly). And so on.

Thank you for the help. I was thinking of using the TREND formula but wasn't sure if it would work on a graph.

Originally Posted by Ochimus

You can start by showing the intersection?

https://engineerexcel.com/2-ways-to-...scatter-chart/

Article covers both Scatter AND line charts.

Hope it helps

Ochimus

Thanks. I will read into that as well.