| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pivot table/chart - can I use data ranges? why will it not group d
Is there a way to categorize data by named ranges of the column headings
rather than individual column headings? Excell will not allow me to group the data. 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 | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| Pivot Table Data Field Query | Excel Worksheet Functions | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| create one pivot from mulitple data sources | Excel Discussion (Misc queries) | |||
| Pivot Table - Group by Month - Show Items with no data | Excel Discussion (Misc queries) | |||
Linear Mode
