First make your data in a table with the following columns (in this order!)
MaxRange, MinRange, Actual

Then plot the graph as a Custom Type "Line-Column".

To get the actuals to appear as points, just format the line as single Points.

To get the bars to appear as ranges. On their for format menu, go to options
and set the Overlap to 100. Now make the Lower range bar the same colour as
the background and it will magically appear like a floating range (when it is
really just a short bar drawn over a taller bar)