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.