software

Hello all,

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

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: www.excelforum.com/attachment.php?postid=4329 |
-------------------------------------------------------------------

--
The_Fairy
------------------------------------------------------------------------
The_Fairy's Profile: www.excelforum.com/member.php...oamp;userid=31257
View this thread: www.excelforum.com/showthread...hreadid=509308Hi,

Create a normal cluster bar chart based on staggered data.

A1:=NB1:=4
A2:=Ngt;CB2:=3
A3:=N=CB3:=3
A4:=NC4:=4
A5:=Ngt;CC5:=4
A6:=N=CC6:=3
A7:=ND7:=3
A8:=Ngt;CD8:=3
A9:=N=CD9:=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:
gt; Hello all,
gt;
gt; I am doing some science work and I really need a chart that looks like
gt; this.
gt;
gt; img230.imageshack.us/img230/6...anation7or.gif
gt;
gt; Can someone please please tell me how the hell do I do it. An example
gt; worksheet would be excellent! I have gone through hell trying to figure
gt; it out with my primitive excel knowledge.
gt;
gt; Thank you in advance!
gt;
gt;
gt; -------------------------------------------------------------------
gt; |Filename: Graph-Explanation.gif |
gt; |Download: www.excelforum.com/attachment.php?postid=4329 |
gt; -------------------------------------------------------------------
gt;

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info


Thank you very much for your help. It worked!!

However I am facing another problem, and I am not sure wether excel can
actually do this. The Bar Graphs that were plotted were based on
averages of certain values. What I need to do is overlay the points
which were used to make the averages over the bar graph. Ie, I need a
Pint plot overlay over the bar graphs. this is very important for data
distribution in my study. I have included a image and a excel file with
some points and I am hoping that someone will be able to help me out
with exactly how I am supposed to do that.

Again, thank you kindly in advance. -------------------------------------------------------------------
|Filename: Explanation.zip |
|Download: www.excelforum.com/attachment.php?postid=4352 |
-------------------------------------------------------------------

--
The_Fairy
------------------------------------------------------------------------
The_Fairy's Profile: www.excelforum.com/member.php...oamp;userid=31257
View this thread: www.excelforum.com/showthread...hreadid=509308