+ Reply to Thread
Results 1 to 2 of 2

Dynamic Chart: comparing 2 parameters by choosing different slicers

  1. #1
    Registered User
    Join Date
    08-11-2017
    Location
    SPB, Russia
    MS-Off Ver
    2010 Professional 14.0.7182.5000 (32-bit)
    Posts
    1

    Dynamic Chart: comparing 2 parameters by choosing different slicers

    Hello.

    I have built dynamic chart. The source is a pivot, made from the database sheet.
    Overall, the tool is available using the link.

    https://ufile.io/9e8ga

    You might note the slicers on the left.

    The case is: I would like to insert kind of secondary axis to choose different parameter on the slicer (different slicer, I mean) simultaneously to benchmark the sites. Is it possible within such dynamic charts?

    Thank you.
    Last edited by survivor48259; 08-11-2017 at 11:49 AM.

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,883

    Re: Dynamic Chart: comparing 2 parameters by choosing different slicers

    You can, but won't advise using slicer to control this.

    If you have more than 2 site selected. It's going to make chart look very busy and hard to read.

    This is done by adding your "Site" field into COLUMNS field.
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

+ 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. Slicers with table and chart
    By Ken0324 in forum Excel General
    Replies: 2
    Last Post: 05-02-2017, 01:47 PM
  2. Dynamic Chart in Excel comparing two years of data by month
    By someko in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-13-2017, 11:10 AM
  3. Not getting the desired chart when using Slicers
    By bapswarrior in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-18-2016, 03:16 PM
  4. Selecting Slicers in a Pivot Chart
    By joe31623 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-10-2015, 03:50 AM
  5. [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
  6. slicers in pivot chart
    By ammartino44 in forum Excel General
    Replies: 1
    Last Post: 06-24-2015, 02:24 PM
  7. Dynamic Buttons for Choosing Areas to display in Diagram
    By Bim1 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-11-2014, 05:12 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