ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How to mix a stacked column and a clustered one on same graph? (https://www.excelbanter.com/charts-charting-excel/43866-how-mix-stacked-column-clustered-one-same-graph.html)

Armelle

How to mix a stacked column and a clustered one on same graph?
 
I want to display on the same graph 2 subtotal informations letùs say sub1
and sub2 for 10 years to show decrease of one and increase of the other in
parallel. The best is then to used clustered column. But sub1 is build for 2
products5(A and B) and sub2 is coming from 3 infos D,E and F.
I would like then to see the split between A and B on the first column
representing sub1 and the same for sub2. It will then be on stacked columns.
Is it possible? Thanks

Debra Dalgleish

Jon Peltier has information and links for clustered stacked columns on
his web site:

http://peltiertech.com/Excel/ChartsH...sterStack.html


Armelle wrote:
I want to display on the same graph 2 subtotal informations letùs say sub1
and sub2 for 10 years to show decrease of one and increase of the other in
parallel. The best is then to used clustered column. But sub1 is build for 2
products5(A and B) and sub2 is coming from 3 infos D,E and F.
I would like then to see the split between A and B on the first column
representing sub1 and the same for sub2. It will then be on stacked columns.
Is it possible? Thanks



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 12:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com