Plotting coordinates,connect points

Hello guys,

I tried to find a way of plotting some points using coordinates but unsuccessfully.
Please help me to solve it.
I really appreciate your help!
I attached a test file, there are some points with coordinates, the result is a route, and another
set of coordinates-the result is an area.

Currently those values will be treated as text and therefore plot as zero.

You need to strip the NEWS info off and adjust the value +/-.
I have assumed the values are absolute so you may need to alter the formula if the information is relative.

For the area you need to include the start/finish point twice to enclose it.

Data labels are linked to cells to display location name.

Thanks a lot Andy, it's almost what I am after to. I think I get the idea how to change the coordinates. Is possible to have the "whole" picture as the latitude/long are in real life? I mean LBSF (Sofia) is somewhere in SE and EGLL (Heathrow) in NW, the contaminated area is located in Iceland.
Thanks again!

after that, in order to be easier for my colleagues I'll try to use a UserForm, not very sure I could do it but I try....

The formula where incorrect. Mixing NS with XY coordinates

I have corrected the formula.

Excellent!!!!! Thanks a lot for your help!

This thread is solved.
The solution is great! I am able to plot the routes and the restricted/warning area.
Is possible to incorporate this solution into a UserForm or something else because the users need to change all the time range(s), and yesterday two of them already messed up...

Not sure how a userform would help.

I guess it depends what the users are doing to screw the chart up. Are they suppose to do anything other than look at the chart? If so just move the chart to a chart sheet and protect the sheet.

If they are suppose to enter new information then look in to using named ranges to automatically updating the chart series.

yes, they need to add new info, route and the restrcted area, because the coordinates are changing ...due to wind. they need to see if the route(s) is in/near/far away from red area!

The route series is not too difficult as that is a contiuous set of coords. Although you will need to update the data labels to show airport codes.

The areas one is more complicated as you need to duplicate start coordinates in order to enclode the area. If you have multiple areas you need to leave a blank cell between areas to avoid drawing a line between areas.

Maybe using a userform to enter coords is the safest way.

Even if we are facing with more restricted areas, we can add one by one, I do not dare to add more than one!
the process is: add info(coordinates) for one route and for the restricted area, it depends where you are, in the middle east or central/north europe. once you add them you see if you are affected or not.
(we have many applications but each o them lacks something)
all I want is to make this process a little bit "secure", how the user can avoid the change the range(s) i.e for min/max? I'd like just to add coordinates only in designated area...is possible, how do I do this?

You could set the axis to auto. Otherwise you would need vba to link charts axis to cell values in order to update.

Thanks! I am not sure I can do it, I let the file in this format for use, I know it helps them a lot!