+ Reply to Thread
Results 1 to 3 of 3

Excel 2010 Slicer to add Days

  1. #1
    Forum Contributor
    Join Date
    03-23-2011
    Location
    Ormesby
    MS-Off Ver
    Microsoft 365 MSO
    Posts
    128

    Excel 2010 Slicer to add Days

    Hello,

    I use Excel 2010 at work and need to know how to get the Slicer to pull Days.
    I have opened Slicer but it only shows Months but not Days.added, so I can
    How can I have Days added to the worksheet, so I can use it to choose the Days I require?

    Many thanks

    Pugg

  2. #2
    Forum Contributor
    Join Date
    03-23-2011
    Location
    Ormesby
    MS-Off Ver
    Microsoft 365 MSO
    Posts
    128

    Re: Excel 2010 Slicer to add Days

    It may not be possible but would be great to know if there are anyone out there who is able to help

    Many thanks

    Pugg

  3. #3
    Forum Expert Roel Jongman's Avatar
    Join Date
    03-28-2015
    Location
    Netherlands
    MS-Off Ver
    Office 365
    Posts
    1,373

    Re: Excel 2010 Slicer to add Days

    Slicers can only reflect values that are actually in the underlying data so if you have a column formatted as months (or have month-like numbers or names) it can only show months.
    you may have to create an extra column to extract a day from the date so you can make a day slicer

+ 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. Excel Timeline Slicer not working in formula for days
    By TheCman81 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-11-2019, 02:34 PM
  2. Loop through slicer, while also selecting single slicer value on separate slicer
    By as_sass in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-30-2018, 01:41 PM
  3. Replies: 1
    Last Post: 04-23-2018, 09:43 AM
  4. Excel 2010 vs. Excel 2016 Slicer
    By mycon73 in forum Excel General
    Replies: 0
    Last Post: 03-18-2016, 12:40 AM
  5. Is this a common Slicer problem from 2013 to 2010?
    By liquidmettle in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 12-14-2015, 05:26 PM
  6. Network Days help please - Excel 2010
    By zeppelinmike in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-14-2014, 06:11 AM
  7. Replies: 2
    Last Post: 09-15-2010, 09:28 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