+ Reply to Thread
Results 1 to 2 of 2

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

  1. #1
    Registered User
    Join Date
    12-29-2014
    Location
    My cube
    MS-Off Ver
    2016
    Posts
    16

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

    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.
    Attached Files Attached Files

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,410

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

    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.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Pivot table showing / comparing information from multiple columns
    By NiranNiran in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 11-25-2015, 11:00 AM
  2. [SOLVED] Pivot Table- Data no longer in table source still showing
    By Smally in forum Excel General
    Replies: 7
    Last Post: 09-10-2014, 11:23 AM
  3. Replies: 4
    Last Post: 06-19-2014, 12:59 PM
  4. Multiple pivot table graphs
    By alexander.small in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-17-2014, 07:28 AM
  5. Replies: 1
    Last Post: 06-16-2013, 07:36 AM
  6. Multiple Pivot for a single Dynamic table and Graph
    By bonz_excel in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-06-2012, 03:12 PM
  7. show multiple dates in pivot table graph
    By interested in forum Excel General
    Replies: 7
    Last Post: 01-20-2012, 02:36 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1