Yes. This is possible. Just add Pivot Charts from the Analyze (or Options) menu of Pivot Table. Multiple charts can be added. Choose different visualization for each chart to get varied views of the same data. For example, column chart for comparison and 100% column chart for viewing the relative distribution.
Refer to the previous post. We saw how Filter fields can be exploded into individual sheets and files. In this article, I am releasing a macro – which does all the hard work for you. Of course, you must use it at your own risk. The source code is also included for you to view, learn from and modify. Created by Raj Chaudhuri and myself.
Suppose you have Products in Filter area and Pivot Table shows Regional Sales by Month. There are 5 products. You want five sheets for each product separately. But not by doing this manually. Here is how you do it (Reading time 7 min)