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