+ Reply to Thread
Results 1 to 2 of 2

Charts and Slicer

  1. #1
    Registered User
    Join Date
    05-20-2016
    Location
    Toronto
    MS-Off Ver
    2013
    Posts
    1

    Charts and Slicer

    Hi All,
    Does anyone know how to keep Chart filtered to Top 10 after using slicer?
    What I am saying is that I created a pivot table and filtered Value to Top 10, than created a pivot chart off that table, and than slicer.
    Now, every time I used slicer that Chart gets messed up ... it sort of "unfilteres" that Top 10 values and instead displays as many rows as chart size fits.
    Does any one know what do I need to do to prevent this from happening?

    Thanks much.

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Charts and Slicer

    I think you would have to attach a few lines of code to automate the selection of top 10 with a pivot update event.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

+ 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. Can I Sync a Slicer to Another Slicer If....
    By Polak in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-04-2015, 12:35 AM
  2. Two different Pie Charts based on selected slicer field
    By superglenntot in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-10-2014, 03:56 AM
  3. Two different Charts based on selected slicer field
    By superglenntot in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-10-2014, 02:03 AM
  4. Make one slicer mirror filters of another slicer
    By IbenezPrez in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-28-2014, 02:00 PM
  5. [SOLVED] Insert Slicer for Pivots Only or can we use it for Charts without Pivots?
    By eldwardo in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-02-2013, 04:27 AM
  6. Slicer Macro - unfilter another slicer on selection
    By chadheins in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-24-2012, 10:41 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