A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

3Axis Multiple groups with subgroup Bar Chart please help!



 
 
Thread Tools Display Modes
  #1  
Old February 7th, 2006, 01:38 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default 3Axis Multiple groups with subgroup Bar Chart please help!


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 |
+-------------------------------------------------------------------+

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

  #2  
Old February 7th, 2006, 02:33 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default 3Axis Multiple groups with subgroup Bar Chart please help!

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
  #3  
Old February 12th, 2006, 05:14 AM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default 3Axis Multiple groups with subgroup Bar Chart please help!


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

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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a High-Low-Close chart with multiple series? The Chad Charts and Charting 3 June 7th, 2007 06:32 PM
Charts - Multiple Pages of same chart Art Setting Up & Running Reports 3 April 8th, 2005 10:44 PM
Syntax needed to get needed reports Frank Lueder New Users 15 January 6th, 2005 09:39 AM
accessing chart objects via VB CycleMark Charts and Charting 1 October 27th, 2003 05:52 PM
Multiple Conditional Formats for A Chart (Please Help)? Jon Peltier Charts and Charting 0 September 19th, 2003 09:40 PM


All times are GMT +1. The time now is 08:54 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.