A stacked, clustered bar graph?

#1 04-09-2005, 06:06 PM

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.

#2 04-10-2005, 11:06 AM

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/E...ps/Columns.htm

and Jon Peltier has links to other sites with information:

http://peltiertech.com/Excel/ChartsH...sterStack.html

Robyn wrote:
> 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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)