I will present this solution with a warning: it is a bit clumsy if you are dealing with a small database because what you do is to change the database by changing the input range by leaving off one row of data. It always does this until you tell it not to. This happens because Excel anticipates your memory and other system needs and bases both PTs and PCs on the same cache of data. The problem is that when I change the grouping in my second PT and in my new PC, the first PT and PC also change. In the second case I grouped the dates under … Year + Days In the first case I grouped the dates under … Years + Quarters + Months To make the changes we see so far, you just change the groupings for the new PT. Good! Now imagine we want a new time series PC, with the PT revised as you can see below and to do this I had to create a new PT based on the existing database that I also used for the first PT and PC: You can see how I did this from this overview screenshot:
Go on, then! You’ve got some data and you know you want to analyse it so off you go! You might have a PT like this: This page explains two approaches to dealing with this issue. There is a problem, though, when you might want to create two or more different charts from the same PT. It is not too difficult to create a pivot chart (PC) either. It is pretty easy these days to set up and manage a pivot table (PT).
