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: www.excelforum.com/member.php...oamp;userid=31118
View this thread: www.excelforum.com/showthread...hreadid=507850Here are some links that show how to do this:
peltiertech.com/Excel/ChartsH...sterStack.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______quot;mariabquot; gt; wrote in
message ...
gt;
gt; I know how to produce group and a stacked bar graphs, but I do not know
gt; how to combine the two designs into one graph.
gt;
gt; For example, Item A and B on the x axis each have 4 bars grouped
gt; together. Now, I'd like to have additional information stacked withing
gt; each of these 4 bars.
gt;
gt; Any insight would be greatly appreciated!
gt;
gt;
gt; --
gt; mariab
gt; ------------------------------------------------------------------------
gt; mariab's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31118
gt; View this thread: www.excelforum.com/showthread...hreadid=507850
gt;
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?--
mariab
------------------------------------------------------------------------
mariab's Profile: www.excelforum.com/member.php...oamp;userid=31118
View this thread: www.excelforum.com/showthread...hreadid=507850
- Dec 18 Thu 2008 20:48
Charts
close
全站熱搜
留言列表
發表留言