Create multiple pivot charts from one pivot table

Is it possible to create multiple charts from one pivot table - ideally without VBA?

I found a response on another forum saying this was possible and describing the basic steps, but there was no sample data, and I can't get the steps to work with my data.

Attached is a sample data file. My actual data can have about 10,000 to 50,000 rows.

Each record represents an item being sold.

This file has 3 worksheets. One sheet for data, one for the pivot table, and one where I'd like to put an assortment of graphs that get built from the pivot table data.

Specifically, in the Charts worksheet, I'd like one chart that shows Total items sold by month.

I would then like two more charts for Total items, one for the Total sold in the Region = AX2, and another chart for the Total sold in the Region = SCC. This is not all of the Regions, only 2 specific Regions of interest.

Finally, still on this Charts worksheet, I'd also like one chart showing the Profit Score for all the Regions, and then two more charts showing the Profit Score for just my 2 high interest Regions of AX2 and SCC.

Can someone help?

It would help if you included a link to the other forum you mention.

I'm pretty sure you need a pt and chart for each unique arrangement of the pivot table.

The solution in that thread is to create a pivot table with all the data you requrie. Then using the GETPIVOTDATA formula build a matrix of data upon which to create a chart. The chart is not a pivot chart

This will not work for the scenario you describe as you need various pivot table configurations in order to get different data sets. The only one that might suit is the Total per region where you could build chart data from different formula on the same pivot table.

Can what be done with VBA?

Manually or with code a PT chart will display the contents of a PT table.

If you require 2 charts with 2 different views of the PT table you need 2 PT tables.

Originally Posted by SueWithQuestion

Is it possible to create multiple charts from one pivot table - ideally without VBA?
Can someone help?

Hi

Take a look at the attached file and see if it provides what you want.
I created 3 separate named ranges, Data1, Data2 and Data3 as dynamic ranges all referring to the same set of data on sheet data.

data1 = Data!$A$1:INDEX(Data!$D:$D,COUNTA(Data!$A:$A))

I set the source for your existing PT as data1 and created a Graph from it will all regions selected.
I then created 2 further PT's on sheet PT2 and PT3, based upon data2 and data3 then selected the relevant region on each and created a chart, which I placed on sheet Pivot Table below the existing graph.

As each chart is based upon a separate Pivot table cache, all of which are based on the same source data, each will adjust to any changes or additions to the source data, when they are refreshed.

Changing the region selected on the first PT from All to any individual region, will alter that PT and the first chart, but because the caches are different, it will not alter the second and third chart.