I'm facing a condition where I'd need to plot some graph similar to this:

where 2 items share the same x axis represents the upper and lower bound, and should be joined by a line in the graph.

This is what I currently do to plot the chart I wanted:

Currently I manually add each entry series to plot the graph, which certainly will fail if the number of items increases. Is there any way to force Excel to use custom Entries / Series arrangement when a selected range is supplied to the chart, such that the desired chart can be created with minimum time? Or are there better ways to solve this problem?