How to make graph gene position in chromosome?

Question

[amirandi1808]

Dear all!

I have some data contain nucleotide position in Mbp, LOD, gene, gene position (start-end), and chromosome. You could find my data here data example

I would like to make plot with Y-axis contain LOD, x-axis contain nucleotide position and gene position. It is difficult but I would like to make the output like this, DATA OUTPUT

I would like to learn how to input data in excel and some packages to make this graph in R studio.

Please help.

I appreciate your kindness!