Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
range names in pivot tables
Is there a way to categorize data by named ranges of the column headings
rather than individual column headings? I need to be able to pivot between certain ranges rather than eliminate or add one column at a time. Or perhaps someone can suggest a different way to do it. I need to create 1 chart to pivot between the first 5, 7, 9 and 11 data columns. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Repeats Names in multiple rows | Excel Discussion (Misc queries) | |||
Pivot Tables | Excel Worksheet Functions | |||
Pivot Table - max rows allowed in data range | Excel Discussion (Misc queries) | |||
Do Pivot Tables have an automatic data range expansion? | Excel Discussion (Misc queries) | |||
Pivot Tables | Excel Discussion (Misc queries) |