Results 1 to 2 of 2

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

Threaded View

ohisofly Multiple graphs from pivot... 07-28-2016, 09:13 AM
dflak Re: Multiple graphs from... 07-29-2016, 04:30 PM
  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

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