Separate data series in single chart

Hi

I have been trying to find out solution for my little problem. I have table that has some measured values from three different samples. These samples has following statistics:

High-level
Low-level
Result 1
Result 2
Result 3

And this data is (for now) 3 times in that same chart. I want to have chart, that has these results in vertical bars but these high and low-levels should be as straight line so we can easily see that if some result is "out of scope". Only problem is that in all different data series, those values varies. And Excel (2010) want's to see those as one series (because title is same). Some kind of sample is attached.

chart_separate_series.xlsx

Hello
See the attached reply. Is this what you're trying to achieve? It uses an XY Scatter on the secondary series to add horizontal lines to your column chart, based on the High and Low point values.

Hope this helps.
DBY

Exactly! Thank you and big bow to you DBY!