I know how to produce group and stacked bar graphs, but I do not know how to combine the two designs into one graph.
For example, Item A and B on the x axis each have 4 bars grouped together. Now, I'd like to have additional information stacked withing each of these 4 bars.
Any insight would be greatly appreciated!
Last edited by mariab; 02-02-2006 at 04:18 PM.
Here are some links that show how to do this:
http://peltiertech.com/Excel/ChartsH...sterStack.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
"mariab" <mariab.22mb9y_1138910402.0488@excelforum-nospam.com> wrote in
message news:mariab.22mb9y_1138910402.0488@excelforum-nospam.com...
>
> I know how to produce group and a stacked bar graphs, but I do not know
> how to combine the two designs into one graph.
>
> For example, Item A and B on the x axis each have 4 bars grouped
> together. Now, I'd like to have additional information stacked withing
> each of these 4 bars.
>
> Any insight would be greatly appreciated!
>
>
> --
> mariab
> ------------------------------------------------------------------------
> mariab's Profile:
> http://www.excelforum.com/member.php...o&userid=31118
> View this thread: http://www.excelforum.com/showthread...hreadid=507850
>
Thank you very much for the link! The directions helped me set up this type of graph. I am now having a different problem. I confirmed that I highlighted the correct areas but all of the information is not being displayed within some of the stacked bars. I have 4 stacked bars for one x value and one of them is only showing 10 out of the 16 that is should stack. Any insight?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks