+ Reply to Thread
Results 1 to 3 of 3

Pivot Chart formatting slicers

  1. #1
    Registered User
    Join Date
    07-08-2013
    Location
    Kent, England
    MS-Off Ver
    Excel 2016
    Posts
    71

    Question Pivot Chart formatting slicers

    Hi I wonder if somebody could help me please?

    I have a pivot chart, with 2 department's information. But on the slicer and graph/chart both departments are actually the same colour so I can't distinguish them (identify/separate them) not sure of correct way to describe it.

    I have taken some screen shots. With slicer options deactivated so showing all the data, and then selected one department, which does make the unselected dept paler.

    Its hopefully something very simple.

    I just can't change them.

    Thank you :-)

    Clair

    pivot chart.jpg

    pivot chart.2jpg.jpg
    Thanks
    Clair

  2. #2
    Registered User
    Join Date
    11-08-2018
    Location
    Netherlands
    MS-Off Ver
    365
    Posts
    4

    Re: Pivot Chart formatting slicers

    Hi Clair, i am not sure if this is of any help, but when you select the slicer, you get an extra tab in the menu. There you can select a layout for the slicer (like: Highlighted button blue others white)
    KR Erik

  3. #3
    Registered User
    Join Date
    07-08-2013
    Location
    Kent, England
    MS-Off Ver
    Excel 2016
    Posts
    71

    Re: Pivot Chart formatting slicers

    Thank you :-)

+ 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. Dynamic Pivot Table and Chart Cell References with slicers - HELP
    By wespomeroy in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 02-22-2018, 03:26 PM
  2. Selecting Slicers in a Pivot Chart
    By joe31623 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-10-2015, 03:50 AM
  3. Pivot Table Formatting - Slicers
    By aaaaaron42 in forum Excel General
    Replies: 0
    Last Post: 10-05-2015, 12:59 PM
  4. [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
  5. slicers in pivot chart
    By ammartino44 in forum Excel General
    Replies: 1
    Last Post: 06-24-2015, 02:24 PM
  6. Replies: 1
    Last Post: 06-01-2015, 12:37 AM
  7. Replies: 2
    Last Post: 05-24-2013, 03:58 PM

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