ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Charts (https://www.excelbanter.com/charts-charting-excel/69216-charts.html)

mariab

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


Jon Peltier

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




mariab

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