ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I create stacked columns in xcel rather than side-by-side (https://www.excelbanter.com/charts-charting-excel/27081-how-do-i-create-stacked-columns-xcel-rather-than-side-side.html)

Gin from Boeing

How do I create stacked columns in xcel rather than side-by-side
 
I only get by Level (Level 1, 2,3, 4, 5, K, L, M) side-by-side Gender Headcount
ex: Level 1 has 114 Females / 125 Males
Level 2 has 60 Femals / 101 Males
and so on

The Female column (Stacked Column choice) is beside the Mail Column
I want the column stacked with the Male numbered column on top of Female
numbered column.
thanks.

Jon Peltier

If you want all of the series stacked, simply select the stacked
sub-type under the column type in the Chart Type dialog (Chart menu or
chart wizard).

If you want one set of stacked columns clustered next to another, look
at the links in this page:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Gin from Boeing wrote:

I only get by Level (Level 1, 2,3, 4, 5, K, L, M) side-by-side Gender Headcount
ex: Level 1 has 114 Females / 125 Males
Level 2 has 60 Femals / 101 Males
and so on

The Female column (Stacked Column choice) is beside the Mail Column
I want the column stacked with the Male numbered column on top of Female
numbered column.
thanks.



All times are GMT +1. The time now is 05:43 AM.

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