| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create combination stacked area and line chart? | Charts and Charting in Excel | |||
| Create stacked columns chart but with 2 columns for each x axis? | Charts and Charting in Excel | |||
| To create a stacked column chart and group the stacked bars togeth | Charts and Charting in Excel | |||
| How can I create a stacked bar chart with stacked bars side by | Charts and Charting in Excel | |||
| Can I use side by side colums and stacked columns in same graph? | Charts and Charting in Excel | |||
Hybrid Mode
