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

[agilder]

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 Excel Forum -> http://www.excelforum.com/excel-gen...ith-min-med-and-max-x-values.html#post2548027

 

[VoG]

Perhaps you could use custom error bars http://peltiertech.com/Excel/ChartsHowTo/ErrorBars.html

 

[agilder]

Thank you.

This is very close. The exception is that my xErr is not symmetrical about xMed. xMed-xMin is independent of xMax-xMed. Do you know if your technique about can accommodate this.

Andrew

 

[VoG]

I think so - with the Custom option you can have asymmetric "errors".