Multiple graphs from pivot table, each graph showing different section of pivot table

[ohisofly]

Attached is a sample workbook to help get across what I'm trying to do.

I have a data set with sales by month for stores, and each store is part of a district. There is one pivot table for the stores (with a corresponding slicer) and another pivot table for the districts (with a corresponding slicer).

I would like a graph for the sales by month of each store to be visible, but only if one district is selected. For example if multiple districts were selected on the district slicer, then no graphs would be visible. If only district 1 was selected, then graphs for store A and store B would be visible.

I added a graph and it is dynamic with the slicers, but it shows all of the stores on one graph. I need a separate graph for each store.

slicer.JPG

Any input would be greatly appreciated.

[dflak]

What is the objective here - to have as many charts as there are stores for the district?

The way I'd do this is to write a routine to clear all charts on the page except for the pivot chart (which may even be on another page). When you select a district, it will set a filter on a hidden pivot table that gets a list of stores for that district. Then run through this list of stores and set the filter on the main pivot table, take a snapshot of the pivot chart and place the snapshot picture (metafile image) of the chart on the page.