Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grouping COLUMNS.
Hi, how do I group columns like you group rows ? I'm trying to create a
grouped column for each month and the individual weeks as columns that could be grouped by month. I can group jan wk1-4 but when i try to do the same for feb it just extends the group from jan to include feb. I want be able to '+ expand' & '- collapse' each month independently. Idea's ? January February wk1; wk2; wk3; wk4 wk1; wk2; wk3; wk4 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grouping COLUMNS.
Hi, u need separate column for each month which will be not grouped with week
columns. Either leave this separate column blank or fill it with aggregate value for given month (e.g. sum of values for all weeks in the month), but do not group this column with other (weeks) columns. "stevepru" wrote: Hi, how do I group columns like you group rows ? I'm trying to create a grouped column for each month and the individual weeks as columns that could be grouped by month. I can group jan wk1-4 but when i try to do the same for feb it just extends the group from jan to include feb. I want be able to '+ expand' & '- collapse' each month independently. Idea's ? January February wk1; wk2; wk3; wk4 wk1; wk2; wk3; wk4 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grouping COLUMNS.
DataGroup and OutlineGroup then pick column option in dialog box. (XL
2003) A couple of useful links: http://www.wikihow.com/Group-and-Outline-Excel-Data http://exceltip.com/exceltips.php?view=category&ID=30 (including on how to do it in XL 2007) for instructional videos: http://www.youtube.com/results?searc...uping+in+excel "stevepru" wrote in message ... Hi, how do I group columns like you group rows ? I'm trying to create a grouped column for each month and the individual weeks as columns that could be grouped by month. I can group jan wk1-4 but when i try to do the same for feb it just extends the group from jan to include feb. I want be able to '+ expand' & '- collapse' each month independently. Idea's ? January February wk1; wk2; wk3; wk4 wk1; wk2; wk3; wk4 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Grouping columns | Excel Discussion (Misc queries) | |||
Grouping columns | Excel Discussion (Misc queries) | |||
Help with grouping columns | New Users to Excel | |||
Colour Grouping of Columns | Charts and Charting in Excel | |||
Grouping Columns | Excel Discussion (Misc queries) |