+ Reply to Thread
Results 1 to 3 of 3

How do I connect a splicer to a 9 box chart?

  1. #1
    Registered User
    Join Date
    06-23-2020
    Location
    Fargo, ND
    MS-Off Ver
    2016
    Posts
    1

    How do I connect a splicer to a 9 box chart?

    I am using the idea from this Excel document, but I am unsure on how the 9 Box chart is connected to the splicer?
    Attached Files Attached Files

  2. #2
    Forum Contributor jomaor1's Avatar
    Join Date
    10-08-2018
    Location
    Brasil
    MS-Off Ver
    Excel 2016
    Posts
    177

    Re: How do I connect a splicer to a 9 box chart?

    Hi!
    It's connected by VBA. Press Alt+F11 to open it, apparently this workbook uses Two Modules:

    ModMakeChart & Module2

    Cheers!
    John.

    "I excel at jumping to conclusions"

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: How do I connect a splicer to a 9 box chart?

    The splicer updates the pivot table on the lookup sheet, which in term then runs the event code within that sheet object.
    This then calls the routine MakeChart

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

+ 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. Connect Macro to Dounat-Chart
    By Gamla kläder in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-23-2018, 06:52 AM
  2. Filter table and chart with same splicer
    By charlesfarrell in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 01-04-2018, 06:44 AM
  3. [SOLVED] Splicer works with all charts but one
    By charlesfarrell in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-16-2017, 12:46 PM
  4. Radar chart does not connect across nil value.
    By silverfern in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 09-26-2017, 04:22 AM
  5. How I can connect my data to the chart by combo box
    By pedjvak in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-20-2013, 02:36 AM
  6. Line chart-how to connect all the markers.
    By S K ROY in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-29-2011, 06:52 PM
  7. Connect the dots on a line chart
    By ChemistB in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-27-2009, 06:24 AM

Tags for this Thread

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