Graphing Line Chart using Code

I need help creating a macro that graphs a line chart with markers for the table I attached. I am new to visual basic and not sure how to achieve this. I need two separate graphs. One graph uses the data only for location 1 and other for only location 2. The y-axis is the average and the x-axis is the distance highlighted in blue. I only need the averages from distance 120 to 260. I highlighted the range for the averages in yellow for location 1 and in red for location 2. I will have more headers other than the example spreadsheet so I need it to graph as long as there are so many headers. I need the line width to be 1 pt and the marker width to be .75 pt. If someone could please help I would appreciate it.