Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / April 2005

Tip: Looking for answers? Try searching our database.

A stacked, clustered bar graph?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Robyn - 09 Apr 2005 21:49 GMT
Its hard to explain without going into my particular data.  It's on brain
cells. There's two kinds of cells, in many parts of the brain, for several
treatments.  What I'd like, is to have the x-axis be the areas of the brain,
the y be the cell number, and then have the bars each be stacked with the two
cell types.  Only with the several treatments, it's hard. Like i'd like the
control to be maybe black/gray , then one drug be blue/lt blue, then the
other drug be red/pink, and i'd like to have the three groups for each brain
part.

Only I can't get the new data series to stop stacking.
Debra Dalgleish - 10 Apr 2005 14:03 GMT
If you stagger your data, you can create side-by-side stacked columns.

Bernard Liengme has an example and instructions on his site:
     http://www.stfx.ca/people/bliengme/ExcelTips/Columns.htm

and Jon Peltier has links to other sites with information:

     http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

> Its hard to explain without going into my particular data.  It's on brain
> cells. There's two kinds of cells, in many parts of the brain, for several
[quoted text clipped - 6 lines]
>
> Only I can't get the new data series to stop stacking.

Signature

Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.