![]() |
Charts
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 |
Charts
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" wrote in message ... 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 |
Charts
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: http://www.excelforum.com/member.php...o&userid=31118 View this thread: http://www.excelforum.com/showthread...hreadid=507850 |
All times are GMT +1. The time now is 09:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com