My first chart... failed!

This is my first attempt at creating a chart but I'm needing help.

I'm wanting to plot measurements taken at various points along a distance of 10 miles. The value of these measurements decreases as the distance increases. I want the measurements to appear on the y axis and distance on the x axis.

And here's the tricky part, at least for me. I want the distance scale (x) to run from "0" to "10", and graduated every mile. Zero distance would be at the y axis. The first tick mark would be labeled "1" (mile), the second tick mark, "2" and so on up to "10" at the far right side of the chart.

Tricky Part (cont.): I won't necessarily end up with ten mearsurements to coincide with the ten 1-mile distance points; there may be five, eight, or even 20 measurements taken within this ten mile distance. But of course, I want the measurement points I do end up with plotted at their respective distance point along the distance scale.

I think I'd even like to see a vertical line coming down from each measurement point that hits the distance scale at the distance that mesurement was taken (e.g. 3.4 miles).

This would be a line line chart, where the line would start high on the y axis and slope down to the right as the distance increased.

I'd appreciate any help.

Hi,

To have the set miles across the bottom, use a scatter graph type. Right click on the x scale and set the scale to however you'd like it.
To get verticles from the points to the x axis try error bars set to 100%.
Same with the horizontal.
I'm not sure about diagonals - wouldn't a trend line look better?
Hope it helps...

Your suggestions worked perfectly. Thanks!