X-Y Scatter Chart with min, med and max x-values

I have reached the capacity of my capabilities and need the assistance with creating an Excel Chart.

I have a table of test data with the following five columns of data: HEADING (Value 1, ....)

"Data point labels" (A, B, C, D, E)
"Minimum x-value" (30, 20, 29, 32, 28)
"Maximum x-value" (75, 80, 90, 71, 68)
"Median x-value" (52, 48, 45, 55, 59)
"y-value" (1,4,9,16,25)

Data rules

"y-values" will always be between 1 and 25.
"x-values" will always be between 1000 and 4000000 (4 Million)
"Minimum x-value" < "Median x-value" < "Maximum x-value"
"Median x-value" is NOT calculated from the other two x-values"
With real data there will be between 50 and 100 data points.

Need from chart

1. An x-y scatter graph plotting all the data points.
2. x-values are plotted with the median data point marker sitting on a horizontal bar representing Minimum to Maximum.
3. Data points are labelled (using XY labeller)
4. Y-axis labelled as "Risk"
5. X-axis labelled as "Value"
6. X-axis to be logarithmic.

Same thread as raised on Mr. Excel -> http://www.mrexcel.com/forum/showthr...79#post2758679