If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
stacking column charts
How do I specify which series of data to stack. Right
now, I have 6 different data series and when I select "stacking chart", it stacks all 6 series in 1 column. I want it to stack 2 series per colunm, totally 3 columns per X (date) range. PLEASE HELP! |
#2
|
|||
|
|||
stacking column charts
If you stagger your data, you can create side-by-side stacked columns.
For example, with four departments over two years: 2001 2002 DeptA 100 120 DeptB 50 60 DeptC 90 100 DeptD 40 50 Bernard Liengme has an example and instructions on his site: http://www.stfx.ca/people/bliengme/E...ps/Columns.htm and the following MSKB article has an example: XL2000: Creating Charts with Multiple Groups of Stacked Bars http://support.microsoft.com/default.aspx?id=214119 kelly wrote: How do I specify which series of data to stack. Right now, I have 6 different data series and when I select "stacking chart", it stacks all 6 series in 1 column. I want it to stack 2 series per colunm, totally 3 columns per X (date) range. PLEASE HELP! -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Thread Tools | |
Display Modes | |
|
|