ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Stacked column and cluster column on same chart? (https://www.excelbanter.com/charts-charting-excel/58451-stacked-column-cluster-column-same-chart.html)

Sus

Stacked column and cluster column on same chart?
 
Hi,

How do I get both types of chart in the same one? Let's say I have
investments (row1) , distributions (row 2) and value (row3) over a period of
ten quarters. Is it possible to show a stacked column for row 1 and 2 and a
separate column for row 3 during the same quarter?

Thank you!

Debra Dalgleish

Stacked column and cluster column on same chart?
 
Jon Peltier has information and links for clustered stacked columns on
his web site:

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


Sus wrote:
Hi,

How do I get both types of chart in the same one? Let's say I have
investments (row1) , distributions (row 2) and value (row3) over a period of
ten quarters. Is it possible to show a stacked column for row 1 and 2 and a
separate column for row 3 during the same quarter?

Thank you!



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



All times are GMT +1. The time now is 01:36 AM.

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