Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Combo Charts
I'm having trouble making a column chart and having two of the columns be
stacked and the other four as separate columns. I tried to click on the column that I wanted stacked, then went to Chart - Chart Type - Stacked, but it stacked all the columns into one stacked column instead of just the one (and I actually need two columns stacked). I can't choose two columns at the same time to have them stack. Any ideas if this is possible? Thanks. |
#2
|
|||
|
|||
Combo Charts
Excel only lets you stack or cluster the columns. But if you arrange
your data properly, you can make a stacked chart look the way you want. This page has several links to examples that show you haw: http://peltiertech.com/Excel/ChartsH...sterStack.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Carol wrote: I'm having trouble making a column chart and having two of the columns be stacked and the other four as separate columns. I tried to click on the column that I wanted stacked, then went to Chart - Chart Type - Stacked, but it stacked all the columns into one stacked column instead of just the one (and I actually need two columns stacked). I can't choose two columns at the same time to have them stack. Any ideas if this is possible? Thanks. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Combo Charts
This was very helpful. Now I'll try to add several additional "unstacked"
columns to the data and see if it works properly. Thank you. "Jon Peltier" wrote: Excel only lets you stack or cluster the columns. But if you arrange your data properly, you can make a stacked chart look the way you want. This page has several links to examples that show you haw: http://peltiertech.com/Excel/ChartsH...sterStack.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Carol wrote: I'm having trouble making a column chart and having two of the columns be stacked and the other four as separate columns. I tried to click on the column that I wanted stacked, then went to Chart - Chart Type - Stacked, but it stacked all the columns into one stacked column instead of just the one (and I actually need two columns stacked). I can't choose two columns at the same time to have them stack. Any ideas if this is possible? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combo Boxes in Charts | Excel Discussion (Misc queries) | |||
Combo Box font size in Charts | Charts and Charting in Excel | |||
Nesting Combo Boxes /Returning an Array | Excel Discussion (Misc queries) | |||
Combo Charts | Excel Worksheet Functions | |||
Double combo charts - are they possible? | Charts and Charting in Excel |