Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does the pivot table not allow me to group data?
I need to group the data in a pivot table, why will it not allow me to?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does the pivot table not allow me to group data?
If the field in the source data contains blank cells, or cells with
text, you won't be able to group the data. There are some suggestions here for fixing the problem: http://www.contextures.com/xlPivot07.html#Problems Forrest wrote: I need to group the data in a pivot table, why will it not allow me to? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does the pivot table not allow me to group data?
The tip did not help however, since you wrote the book, literally, let me
explain what I need to do. I need to produce a series of charts that pivot between 5,7,9 and 11 columns of data, so the number of x axis values will change and the chart has to expand or shrink to fit the data. It cannot show blank values. I can accomplish this by turning off or on the data values, but they need to be pivoted by group not by indivudual column. Please help. "Debra Dalgleish" wrote: If the field in the source data contains blank cells, or cells with text, you won't be able to group the data. There are some suggestions here for fixing the problem: http://www.contextures.com/xlPivot07.html#Problems Forrest wrote: I need to group the data in a pivot table, why will it not allow me to? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does the pivot table not allow me to group data?
Can you give an example of what you're trying to do, and the data you
want to group? Forrest wrote: The tip did not help however, since you wrote the book, literally, let me explain what I need to do. I need to produce a series of charts that pivot between 5,7,9 and 11 columns of data, so the number of x axis values will change and the chart has to expand or shrink to fit the data. It cannot show blank values. I can accomplish this by turning off or on the data values, but they need to be pivoted by group not by indivudual column. Please help. "Debra Dalgleish" wrote: If the field in the source data contains blank cells, or cells with text, you won't be able to group the data. There are some suggestions here for fixing the problem: http://www.contextures.com/xlPivot07.html#Problems Forrest wrote: I need to group the data in a pivot table, why will it not allow me to? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does the pivot table not allow me to group data?
Ok, I have produced a spreadsheet that calculates cuts for wood strips called
"camber" for beam deflection during bridge construction. Camber strips are placed along the length of a beam and start at 5/8" at each end and can go as high as 6" in the center in a parbolic arc. Beam spans may be up to 90 feet long, but the individual pieces of wood can only be 10' long maximum and are cut in a straight line, so the intermediate cut heights are interpolated. The camber will be made of either 4 individual wood segments, 6 segments, 8 segments or 10 segments, depending on the span length. column headings read as such (seperated by colon:) Group:HLA:cut1:cut2:cut3:cut4:cut5:cut6:cut7:cut8: cut9:cut10:cut11 Data in the columns might read 1:avg:5/8:3/4:1:3/4:5/8:0:0:0:0:0:0 or possibly 1:avg:5/8:7/8:1:1-1/2:2:1-1/2:1:7/8:5/8:0:0 Don't worry about the group and HLA headings. However, the chart must show cuts 1-5 or cuts 1-7 or cuts 1-9 or cuts 1-11 and 4 charts cannot be shown simultaneously. The data cells will be filled based on the length of the span. the x axis will be plotted as the length of the pieces. I was able to accomplish this previously by overlaying 4 normal charts on top of each other but that has some problems. If I can use the pivot chart to switch between these groups of data it would be much cleaner. "Debra Dalgleish" wrote: Can you give an example of what you're trying to do, and the data you want to group? Forrest wrote: The tip did not help however, since you wrote the book, literally, let me explain what I need to do. I need to produce a series of charts that pivot between 5,7,9 and 11 columns of data, so the number of x axis values will change and the chart has to expand or shrink to fit the data. It cannot show blank values. I can accomplish this by turning off or on the data values, but they need to be pivoted by group not by indivudual column. Please help. "Debra Dalgleish" wrote: If the field in the source data contains blank cells, or cells with text, you won't be able to group the data. There are some suggestions here for fixing the problem: http://www.contextures.com/xlPivot07.html#Problems Forrest wrote: I need to group the data in a pivot table, why will it not allow me to? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does the pivot table not allow me to group data?
Do you need a pivot table for this? Perhaps a dynamic chart would be
better. Jon Peltier has some examples: http://www.peltiertech.com/Excel/Charts/Dynamics.html Forrest wrote: Ok, I have produced a spreadsheet that calculates cuts for wood strips called "camber" for beam deflection during bridge construction. Camber strips are placed along the length of a beam and start at 5/8" at each end and can go as high as 6" in the center in a parbolic arc. Beam spans may be up to 90 feet long, but the individual pieces of wood can only be 10' long maximum and are cut in a straight line, so the intermediate cut heights are interpolated. The camber will be made of either 4 individual wood segments, 6 segments, 8 segments or 10 segments, depending on the span length. column headings read as such (seperated by colon:) Group:HLA:cut1:cut2:cut3:cut4:cut5:cut6:cut7:cut8: cut9:cut10:cut11 Data in the columns might read 1:avg:5/8:3/4:1:3/4:5/8:0:0:0:0:0:0 or possibly 1:avg:5/8:7/8:1:1-1/2:2:1-1/2:1:7/8:5/8:0:0 Don't worry about the group and HLA headings. However, the chart must show cuts 1-5 or cuts 1-7 or cuts 1-9 or cuts 1-11 and 4 charts cannot be shown simultaneously. The data cells will be filled based on the length of the span. the x axis will be plotted as the length of the pieces. I was able to accomplish this previously by overlaying 4 normal charts on top of each other but that has some problems. If I can use the pivot chart to switch between these groups of data it would be much cleaner. "Debra Dalgleish" wrote: Can you give an example of what you're trying to do, and the data you want to group? Forrest wrote: The tip did not help however, since you wrote the book, literally, let me explain what I need to do. I need to produce a series of charts that pivot between 5,7,9 and 11 columns of data, so the number of x axis values will change and the chart has to expand or shrink to fit the data. It cannot show blank values. I can accomplish this by turning off or on the data values, but they need to be pivoted by group not by indivudual column. Please help. "Debra Dalgleish" wrote: If the field in the source data contains blank cells, or cells with text, you won't be able to group the data. There are some suggestions here for fixing the problem: http://www.contextures.com/xlPivot07.html#Problems Forrest wrote: I need to group the data in a pivot table, why will it not allow me to? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does the pivot table not allow me to group data?
I wasn't aware this option existed. It sounds like a good solution possibly.
Thanks. "Debra Dalgleish" wrote: Do you need a pivot table for this? Perhaps a dynamic chart would be better. Jon Peltier has some examples: http://www.peltiertech.com/Excel/Charts/Dynamics.html Forrest wrote: Ok, I have produced a spreadsheet that calculates cuts for wood strips called "camber" for beam deflection during bridge construction. Camber strips are placed along the length of a beam and start at 5/8" at each end and can go as high as 6" in the center in a parbolic arc. Beam spans may be up to 90 feet long, but the individual pieces of wood can only be 10' long maximum and are cut in a straight line, so the intermediate cut heights are interpolated. The camber will be made of either 4 individual wood segments, 6 segments, 8 segments or 10 segments, depending on the span length. column headings read as such (seperated by colon:) Group:HLA:cut1:cut2:cut3:cut4:cut5:cut6:cut7:cut8: cut9:cut10:cut11 Data in the columns might read 1:avg:5/8:3/4:1:3/4:5/8:0:0:0:0:0:0 or possibly 1:avg:5/8:7/8:1:1-1/2:2:1-1/2:1:7/8:5/8:0:0 Don't worry about the group and HLA headings. However, the chart must show cuts 1-5 or cuts 1-7 or cuts 1-9 or cuts 1-11 and 4 charts cannot be shown simultaneously. The data cells will be filled based on the length of the span. the x axis will be plotted as the length of the pieces. I was able to accomplish this previously by overlaying 4 normal charts on top of each other but that has some problems. If I can use the pivot chart to switch between these groups of data it would be much cleaner. "Debra Dalgleish" wrote: Can you give an example of what you're trying to do, and the data you want to group? Forrest wrote: The tip did not help however, since you wrote the book, literally, let me explain what I need to do. I need to produce a series of charts that pivot between 5,7,9 and 11 columns of data, so the number of x axis values will change and the chart has to expand or shrink to fit the data. It cannot show blank values. I can accomplish this by turning off or on the data values, but they need to be pivoted by group not by indivudual column. Please help. "Debra Dalgleish" wrote: If the field in the source data contains blank cells, or cells with text, you won't be able to group the data. There are some suggestions here for fixing the problem: http://www.contextures.com/xlPivot07.html#Problems Forrest wrote: I need to group the data in a pivot table, why will it not allow me to? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table - New Data | Excel Discussion (Misc queries) | |||
get SQL Server text data type into Excel pivot table | Excel Discussion (Misc queries) | |||
Pivot Table Data Filter Problem | Excel Discussion (Misc queries) | |||
Pivot Table for survey data w/ questions as Rows & poss answrs as | Excel Discussion (Misc queries) | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) |