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
|
|||
|
|||
Stacked Columns with multiple categories
I am using Office 2000. This may be hard to explain, so I
apologize in advance... I have 2 series. 1: Aided (%) 2: Unaided (%) I have these values for two different dates (June and August) and for two different categories (personal and business). I have all of this data for three companies (X, Y and Z). What I would like to see is a stacked column chart showing the series percentages, but the columns grouped by business personal, date and company. So, column group #1 would be for company X and show June personal, June business, august personal, august business... then there would be space before moving on to column group #2 (company Y's figures). I am able to something similar, but the columns are evenly spaced all the way across. Thanks in advance! |
#2
|
|||
|
|||
Stacked Columns with multiple categories
If you add some blank rows to the data, it will add spaces between the
sets of columns. For example: Aided Unaided X June Business 996 589 Personal 235 78 August Business 755 865 Personal 480 297 blank row Y June Business 857 348 Personal 543 960 August Business 149 491 Personal 115 620 Erik wrote: I am using Office 2000. This may be hard to explain, so I apologize in advance... I have 2 series. 1: Aided (%) 2: Unaided (%) I have these values for two different dates (June and August) and for two different categories (personal and business). I have all of this data for three companies (X, Y and Z). What I would like to see is a stacked column chart showing the series percentages, but the columns grouped by business personal, date and company. So, column group #1 would be for company X and show June personal, June business, august personal, august business... then there would be space before moving on to column group #2 (company Y's figures). I am able to something similar, but the columns are evenly spaced all the way across. Thanks in advance! -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Stacked Columns with multiple categories
Erik wrote:
That SOMEWHAT works, but along the X-axis, there are blank labels also. I now have Bus/Pers, Bus/Pers, blank... This effect is similar what I need so I may just have to omit the X-axis labels and insert text boxes manually. Try to put an entry in the first cell of the blank row. Enter something= = like "test" to see what it does. Then replace that "test" with a space = to = remove the label. -- = Dave dvt at psu dot edu |
Thread Tools | |
Display Modes | |
|
|