+ Reply to Thread
Results 1 to 7 of 7

CHANGE data with slicer

  1. #1
    Forum Contributor
    Join Date
    05-09-2015
    Location
    Thailand
    MS-Off Ver
    MS365
    Posts
    303

    CHANGE data with slicer

    Dear Expert
    I 've create graph to connect from Slicer and pivot.
    first graph , no filter any field in Slicer in sheet Slicer. will show as attached picture.
    bar and line. but when i click slicer by field and show all bar and after clear all slicer. graph still show bar , no line in secondary axis.
    How i can set for this?
    please kindly suggest.
    thanks and kind regards.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    05-09-2015
    Location
    Thailand
    MS-Off Ver
    MS365
    Posts
    303

    Re: CHANGE data with slicer

    Please see picture file.

  3. #3
    Registered User
    Join Date
    07-14-2013
    Location
    USA
    MS-Off Ver
    MS 365
    Posts
    97

    Re: CHANGE data with slicer

    Click on each slicer individually, then under the slicer contextual menu, select options, then click on slicer connections. Next click the checkbox for pivot table 1. Do this for each slicer you want to connect.

  4. #4
    Forum Contributor
    Join Date
    05-09-2015
    Location
    Thailand
    MS-Off Ver
    MS365
    Posts
    303

    Re: CHANGE data with slicer

    HI XL AND ME
    thanks a lot for your reply.
    how can i know that name of pivot? first pivot is pivot 1 right?in case i don't state the name of pivot

  5. #5
    Forum Contributor
    Join Date
    05-09-2015
    Location
    Thailand
    MS-Off Ver
    MS365
    Posts
    303

    Re: CHANGE data with slicer

    I've tried in your attached file but still same.? Not change back to line and bar chart. Pls suggest that i'm wrong any?

  6. #6
    Forum Contributor
    Join Date
    05-09-2015
    Location
    Thailand
    MS-Off Ver
    MS365
    Posts
    303

    Re: CHANGE data with slicer

    hi
    i've attached picture how to set for slicer. it's correct? pls suggest.
    Attached Images Attached Images

  7. #7
    Registered User
    Join Date
    07-14-2013
    Location
    USA
    MS-Off Ver
    MS 365
    Posts
    97

    Re: CHANGE data with slicer

    Kimudao, I have tried some ideas and cannot seem to answer your problem. It may have something to do with count of code2. When I tried to recreate your problem using my own data, I could not duplicate your problem. Not sure what is going on. Hopefully someone else in the forum can help you on this.

+ 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. [SOLVED] Pivot chart won't change when I add months using the slicer
    By Mrs.H in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 12-02-2015, 04:59 PM
  2. How can I change the format of values displayed in a slicer?
    By Packerbacker in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 08-18-2015, 09:55 PM
  3. How to change font size of a pivot Slicer, using VBA
    By Jaffary in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-11-2015, 11:41 AM
  4. Detect a change in a Slicer
    By npatridge in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-16-2015, 05:49 PM
  5. VBA to change pivot slicer based on cell value
    By Samantha McNeill in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-07-2015, 06:20 PM
  6. Slicer Change Event
    By DuncR6 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-12-2013, 04:59 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