Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I show negative numbers on a stacked graph | Charts and Charting in Excel | |||
Stacked + Clustered | Charts and Charting in Excel | |||
combination of stacked and clustered column | Charts and Charting in Excel | |||
Clustered column chart with stacked coumns | Charts and Charting in Excel | |||
Can I use side by side colums and stacked columns in same graph? | Charts and Charting in Excel |