Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column with Stacked Column
I have three rows of financial (three scenarios) data for 5 years. I would
like to compare a chart of column for first scenarios vs. a stack column(for the total of second scenario and third scenario together). I know I need to set up a combination chart...can anyone explain to me how I am supposed to do it? I tried three rows first with column chart... and was trying to change the second and third column to stacked column... however, all three columns changes to stacked column, which is not what I want. I still want to main the first column but only the second and third combined to one stacked column... Can anyone please help me? THanks, Ally |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column with Stacked Column
Jon Peltier has information and links for clustered stacked columns on
his web site: http://peltiertech.com/Excel/ChartsH...sterStack.html You could adapt one of those techniques to create the stacked column and single column. Ally wrote: I have three rows of financial (three scenarios) data for 5 years. I would like to compare a chart of column for first scenarios vs. a stack column(for the total of second scenario and third scenario together). I know I need to set up a combination chart...can anyone explain to me how I am supposed to do it? I tried three rows first with column chart... and was trying to change the second and third column to stacked column... however, all three columns changes to stacked column, which is not what I want. I still want to main the first column but only the second and third combined to one stacked column... Can anyone please help me? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stacked column chart wit more than one column in a data point | Charts and Charting in Excel | |||
Needed: Chart that combines clustered column and stacked column types | Charts and Charting in Excel | |||
How to combine stacked column with a cluster column chart? | Charts and Charting in Excel | |||
How do I combine stacked column and single column graphs? | Excel Discussion (Misc queries) | |||
How do you combine a stacked column and single column graph? | Charts and Charting in Excel |