Excel multiple grouping on table for different pivot tables?

I am using Excel 2007 and using several pivot charts which reference the same table of data. I change the data daily, copy and pasting the data from another source. Is it possible to change the grouping on the table so that I can view the data dif开发者_JAVA技巧ferently in different pivot tables? For example, one graph views the data by hour and another by month and another by day. It seems that when I change the grouping for one graph, it changes it on every one. My solution has been to copy and paste in the data into three separate tables for data with each one having different groupings.

The most flexible solution is to split dates in different columns and calculate all the aggregation levels needed using

 - =YEAR([date]), =MONTH([date]), =DAY([date]), =HOUR([date]), =MINUTE([date])
 - =CEILING(MONTH([date])/3;1) for quarter

and pull these fields in & out of your Pivot tables / charts.