+ Reply to Thread
Results 1 to 4 of 4

Horizontal Slicer in a table

  1. #1
    Registered User
    Join Date
    04-08-2013
    Location
    Wajdušna
    MS-Off Ver
    Office 365
    Posts
    79

    Horizontal Slicer in a table

    Hello,

    I have a table:
    Year a b c
    1 2 3 4
    2 3 4 5
    I want to put two slicers, first Slicer is for column Years and this is not a problem, but i want to incorrporate another slice from the same table where i could choose between columns A, B and C?
    Is this possible and if it is how? Do i have to rearange my data or can i do it in some other way ?

  2. #2
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: Horizontal Slicer in a table

    Hi,

    Something like this?

    See the attached file.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    04-08-2013
    Location
    Wajdušna
    MS-Off Ver
    Office 365
    Posts
    79

    Re: Horizontal Slicer in a table

    Hm probably not, in a table like this i want to insert slicer for years, and then a slicer that would alow me to chose betwen columns A B and C, not the values under A B C like is the case with column Years.
    To recap my first slicer should alow me to chose betwen years 1,2,3,......20 and the other where i could choose between product A, B, C. So basicly with slicers i would be able to filter lets say first 3 years and then with the second one just products A and C.
    Cuz i need this for a graph, I did this with using check boxes but its not the most elegant solution, so i wonder if there is way to this with slicers.
    img.jpgimg.jpg

  4. #4
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Horizontal Slicer in a table

    Hi,

    I think you would have to rearrange the data into three columns- year, type (a, b, or c) and value.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

+ 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. Slicer table error
    By brohde in forum Excel General
    Replies: 0
    Last Post: 04-04-2017, 05:49 PM
  2. Pivot Table and Slicer Help
    By matt85webb in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 09-28-2016, 11:14 AM
  3. Pivot table and slicer help
    By finchfinch in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 06-23-2016, 07:36 AM
  4. [SOLVED] Pivot Table Slicer function
    By ChemistB in forum Excel General
    Replies: 3
    Last Post: 09-28-2015, 09:09 AM
  5. [SOLVED] how to arrange slicer look from vertical to horizontal?
    By koi in forum Excel General
    Replies: 1
    Last Post: 10-29-2012, 03:39 AM
  6. Pivot Table (Slicer) Help
    By skate1991 in forum Excel General
    Replies: 0
    Last Post: 10-11-2012, 11:52 AM
  7. [SOLVED] Change Chart Title Depending on a Slicer - slicer advice
    By JungleJme in forum Excel General
    Replies: 8
    Last Post: 08-17-2012, 07:59 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