Plotting chart with defined start/end points on xy axis

[Tina Nguyen 2]

Hello,

I need to create a scatter plot based on this type ofdata.

 

 

 

 

Filling

 

 

Long Start

 

 

Long End

 

 

Dmzstart

 

 

Dmz End

 

 

 

 

1

 

 

35

 

 

37,5

 

 

14,2

 

 

15,3

 

 

 

 

2

 

 

35,9

 

 

39,1

 

 

14

 

 

15,2

 

 

 

 

3

 

 

36,1

 

 

37,8

 

 

13

 

 

14,1

 

 

 

 

4

 

 

38

 

 

39,5

 

 

13,2

 

 

14,5

 

 

 

 

As a result, I would like to create a chart with 2 axis Longitude (Y) and Dmz (x) with a custom scale interval (0.75 instead of 1).On the example, form 1 (green rectangle) representsfilling 1 , each fields is a cornerLong Start (bottom left), Long End (bottom right), Dmz start (up left) and dmz End (up right). How would you place the 4 forms, fill them up and create a layering effect

How would you generate a calculated column thattotal number of layering (x fillings)

 

Would appreciate your help,

 

Thank you,