JNieuwsma
Mechanical
- Apr 9, 2003
- 69
Hi all--
Does anyone know if/how one can create bar charts in Excel that are both grouped and stacked? I have a series of products for which I want to show the cost structure in one stacked column (material/labor/overhead/etc), next to the market price in a separate column.
I can almost get there by working only in stacked mode as follows (I hope this works):
Product A Product B Product C
material x x x
labor x x x
overhead x x x
market price x x x
The problem with this method is that a) it's a hassle to manipulate the data, and b) the cost/price colums for a given product are not grouped together and the graph is too spread out.
Any suggestions?
Jonathan Nieuwsma
Does anyone know if/how one can create bar charts in Excel that are both grouped and stacked? I have a series of products for which I want to show the cost structure in one stacked column (material/labor/overhead/etc), next to the market price in a separate column.
I can almost get there by working only in stacked mode as follows (I hope this works):
Product A Product B Product C
material x x x
labor x x x
overhead x x x
market price x x x
The problem with this method is that a) it's a hassle to manipulate the data, and b) the cost/price colums for a given product are not grouped together and the graph is too spread out.
Any suggestions?
Jonathan Nieuwsma