+ Reply to Thread
Results 1 to 5 of 5

Print Graphs using Specific Items from Slicer List

  1. #1
    Forum Contributor
    Join Date
    11-28-2005
    Location
    Dover, England
    Posts
    172

    Print Graphs using Specific Items from Slicer List

    I complete a daily report which I print before publishing. I print the majority of pages using a macro but I have a graph, which i use a slicer to change 4 bits of constant criteria and manually print each one off. I am looking for a vba solution which will loop through each of the critia select and print each of the graphs. Thanks

  2. #2
    Forum Contributor
    Join Date
    11-28-2005
    Location
    Dover, England
    Posts
    172

    Re: Print Graphs using Specific Items from Slicer List

    I can tell that this has been a challenge so could I ask someone to advise me as to what I am seeking is just a pipe dream, so that I don't waste anymore time looking for a solution. Cheers

  3. #3
    Registered User
    Join Date
    04-10-2014
    Location
    Tallahassee, FL
    MS-Off Ver
    Excel 2010
    Posts
    98

    Re: Print Graphs using Specific Items from Slicer List

    You have not provided any information from which someone can build such a piece of code.

    Pivot Tables are VERY particular about how macro code is written for them. We would need to know the name of the pivot table, the field names, which data records are being sliced, and a few other things I can't recall off the top of my head.

    It isn't difficulty, it is about a lack of information.

  4. #4
    Forum Contributor
    Join Date
    11-28-2005
    Location
    Dover, England
    Posts
    172

    Re: Print Graphs using Specific Items from Slicer List

    Phixer, thanks for the prompt. I have attached a small sample of the data I am using and what is needed to print.
    Bascially, I need to loop through and print the graph with each of the 4 CAPSIT's. Thanks
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    11-28-2005
    Location
    Dover, England
    Posts
    172

    Re: Print Graphs using Specific Items from Slicer List

    Once again I would ask is it possible to print the specific sheets using vba? Thanks

+ 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. Slicer for Top 5, 10, 15 items by Sum
    By DKolev in forum Excel Charting & Pivots
    Replies: 15
    Last Post: 12-06-2016, 05:29 AM
  2. Deselect all pivot slicer items
    By K1M6O in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-02-2014, 04:37 AM
  3. Replies: 1
    Last Post: 03-18-2014, 02:19 PM
  4. Select Multiple Items in a List and then Print Those Items
    By dcdoc in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-26-2013, 01:16 PM
  5. Graphs Disappear With Linked Slicer?
    By excelnewbie123 in forum Excel General
    Replies: 2
    Last Post: 04-15-2011, 02:37 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