+ Reply to Thread
Results 1 to 3 of 3

RESOLVED: Working with Slicers - Pivot charts

  1. 08-28-2013, 07:47 PM #1
    uimhirADo
    uimhirADo is offline
    Registered User
    Join Date
    07-17-2012
    Location
    Auckland
    MS-Off Ver
    Excel 2010
    Posts
    36

    RESOLVED: Working with Slicers - Pivot charts

    Hi
    See attached
    Is there anyway I can get the items listed in SubObj to stop changing order everytime an Object is selected in the Object slicer
    Basically I want the highlighting part to change but I do not want the list order to change.
    Can this be done ??

    Let me know I need to clarify?

    Thanks
    Attached Files Attached Files
    Last edited by uimhirADo; 08-29-2013 at 04:13 PM.
    Reply With QuoteRegister To Reply
  2. 08-29-2013, 10:12 AM #2
    handerson0603
    handerson0603 is offline
    Registered User
    Join Date
    08-27-2010
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    76

    Re: Working with Slicers - Pivot charts

    Right-click on the slicer, select Slicer Settings, and uncheck the box that says "Show items with no data last".
    Reply With QuoteRegister To Reply
  3. 08-29-2013, 04:13 PM #3
    uimhirADo
    uimhirADo is offline
    Registered User
    Join Date
    07-17-2012
    Location
    Auckland
    MS-Off Ver
    Excel 2010
    Posts
    36

    Re: Working with Slicers - Pivot charts

    tk handerson, that does the trick!!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Can you have pivot table fields as slicers?
    By no.18shirt in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-19-2013, 10:39 AM
  2. Pasting Pivot Chart Format or using slicers Changes Pivot Table data Reference
    By Xcelguy in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-24-2013, 03:58 PM
  3. [SOLVED] Pivot Slicers from multiple Caches - problem with 2nd Slicer displaying incorrect data
    By matt4003 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-14-2013, 03:06 AM
  4. Creating simple charts from multiple pivot table charts
    By hovaucf in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-23-2008, 04:13 PM
  5. [SOLVED] Pivot Charts on Web not working
    By [email protected] in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-07-2006, 03:10 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1