+ Reply to Thread
Results 1 to 2 of 2

Slicers; Schedules

  1. #1
    Registered User
    Join Date
    12-06-2017
    Location
    Chicago, IL
    MS-Off Ver
    2016
    Posts
    26

    Slicers; Schedules

    Hi, I have a dashboard that has financial metrics in several charts connected to slicers (project name slicer, date slicer). I'd also like to pull in an 8 week lookahead schedule that can be connected in some way so that it shows the data related to the site/dates that the charts are filtered to. But I don't know how to make a schedule into a pivot table, and I can't figure out how to connect slicers to a regular table. Any ideas?
    Thanks!

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

    Re: Slicers; Schedules

    It sounds like you have two questions: how to get the 8-week look-ahead and how to insert a slicer to a regular table.

    For the 8 week look-ahead, I suggest making a helper column that checks the dates: =AND(Date>+Start_Date,Date<=End_Date) so that the cells evaluate TRUE if the date falls withing the 8-week look-ahead. Then you can filter on this.

    As for inserting a slicer on a table, do it the same way you do it in a pivot table. Put the cursor in the table and Insert -> Slicer. A slicer can be attached to only one table, and if it is attached to a table, then it cannot also be attached to a pivot table.
    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. [SOLVED] Disconnect Slicers, Change Pivot Table Source, Reconnect Slicers: a problem
    By Geoff. in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2015, 02:27 PM
  2. comparing schedules
    By webejamn99 in forum Excel General
    Replies: 8
    Last Post: 06-15-2012, 02:53 AM
  3. Automated schedules
    By wodo5 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-01-2010, 10:56 AM
  4. Help with calculations for schedules
    By SHERBEAR in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 12-02-2006, 01:55 PM
  5. [SOLVED] Day Off schedules
    By Steve in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-18-2006, 03:55 PM
  6. schedules
    By Brad in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-29-2006, 05:40 PM
  7. Schedules
    By bras1l in forum Excel General
    Replies: 0
    Last Post: 02-05-2005, 08:50 AM

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