Hi,

Create a normal cluster bar chart based on staggered data.

A1:=N B1:=4
A2:=NC B2:=3
A3:=N=C B3:=3
A4:=N C4:=4
A5:=NC C5:=4
A6:=N=C C6:=3
A7:=N D7:=3
A8:=NC D8:=3
A9:=N=C D9:=4

Double click one of the bar series and on the Options tab set overlap to
100. Whilst you are there also add Y Error bars to the series. Repeat
error bars for the other 2 series.
Double click the Y axis and plot scale in reverse order to get value
axis at the top and items reading top to bottom.
Right click chart and pick Chart Options and apply Major X axis grid
lines. Double click the Y axis and on the scale tab change the number of
categories between tickmarks to 3.

Cheers
Andy

The_Fairy wrote:
Hello all,

I am doing some science work and I really need a chart that looks like
this.

http://img230.imageshack.us/img230/6...anation7or.gif

Can someone please please tell me how the hell do I do it. An example
worksheet would be excellent! I have gone through hell trying to figure
it out with my primitive excel knowledge.

Thank you in advance!


+-------------------------------------------------------------------+
|Filename: Graph-Explanation.gif |
|Download: http://www.excelforum.com/attachment.php?postid=4329 |
+-------------------------------------------------------------------+


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info