| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Create Stacked column of multiple values across categories
Current Excel is able to create stacked column bars charts only on a single
value across categories, eg, X-axis - Jan, feb, etc, only one stacked bar. Any advise if it is possible to create "stacked colums" comparing "valueS across categories"? (Eg, X-axis - Jan will consite of a few stacked column, feb same few stacked columns, etc) |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Create Stacked column of multiple values across categories
Hi,
Links to cluster/stacks can be found here. http://peltiertech.com/Excel/ChartsH...sterStack.html Cheers Andy Elynn wrote: Current Excel is able to create stacked column bars charts only on a single value across categories, eg, X-axis - Jan, feb, etc, only one stacked bar. Any advise if it is possible to create "stacked colums" comparing "valueS across categories"? (Eg, X-axis - Jan will consite of a few stacked column, feb same few stacked columns, etc) -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Create Stacked column of multiple values across categories
Hi Andy,
thank you. The example shows up to 2 axes (Pri and Secondary) to plot 2 stacked column bars. However, I need to plot 4 columns bars. Possible? "Andy Pope" wrote: Hi, Links to cluster/stacks can be found here. http://peltiertech.com/Excel/ChartsH...sterStack.html Cheers Andy Elynn wrote: Current Excel is able to create stacked column bars charts only on a single value across categories, eg, X-axis - Jan, feb, etc, only one stacked bar. Any advise if it is possible to create "stacked colums" comparing "valueS across categories"? (Eg, X-axis - Jan will consite of a few stacked column, feb same few stacked columns, etc) -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Create Stacked column of multiple values across categories
Hi again! I got the method. Thanks!
"Elynn" wrote: Hi Andy, thank you. The example shows up to 2 axes (Pri and Secondary) to plot 2 stacked column bars. However, I need to plot 4 columns bars. Possible? "Andy Pope" wrote: Hi, Links to cluster/stacks can be found here. http://peltiertech.com/Excel/ChartsH...sterStack.html Cheers Andy Elynn wrote: Current Excel is able to create stacked column bars charts only on a single value across categories, eg, X-axis - Jan, feb, etc, only one stacked bar. Any advise if it is possible to create "stacked colums" comparing "valueS across categories"? (Eg, X-axis - Jan will consite of a few stacked column, feb same few stacked columns, etc) -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro | Excel Discussion (Misc queries) | |||
| macro to change multiple values in a column | Excel Discussion (Misc queries) | |||
| Can we Create a column that receives unique values only? | Excel Discussion (Misc queries) | |||
| create list of unique values from a column with repeated values? | Excel Worksheet Functions | |||
| To create a stacked column chart and group the stacked bars togeth | Charts and Charting in Excel | |||
Hybrid Mode
