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. |
All times are GMT +1. The time now is 10:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com