+ Reply to Thread
Results 1 to 1 of 1

Automatically put dynamic chart in specific PPT slide based on criteria of slicer (VBA)

  1. #1
    Registered User
    Join Date
    03-21-2016
    Location
    Paris
    MS-Off Ver
    2010
    Posts
    3

    Automatically put dynamic chart in specific PPT slide based on criteria of slicer (VBA)

    Dear all,

    I have a report with one dynamic chart in a worksheet called "VIVA GRAPH". In the picture down below you will see on the left hand side two cells that are referring to the pivot table where the slicers are linked to. There are in total 2 (countries) x 9 (models) = 18 possible combinations.

    http://i68.tinypic.com/295y8hu.png

    There is a PowerPoint that has to be updated on a monthly basis. The structure of the PowerPoint won't change, so e.g. the graph regarding "Portugal" & "Note" will be put in slide 8, the combination "Spain" & "Note" will be put in slide 9 etc.

    I have found the first piece of code on the site of JonPeltier where you click on the chart and automatically put it in the PowerPoint. However, I want the VBA to take in account those 2 variables and put the chart into the respected slide. Again, the structure of the PowerPoint won't change!

    Is it possible to create a VBA macro that automatically copy-pastes this one chart into a specific slide? When someone clicks on another criteria it will be put into another slide. This to prevent copy-pasting a lot.

    For some reason I am unable to put the example of my report in the attachments.

    Looking forward to hearing from you.

    Yours sincerely,

    Djani Sadloe
    Last edited by Djanisadloe; 03-21-2016 at 04:45 AM. Reason: additional information

+ 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. Adapt VBA code to place chart on specific slide
    By michelle 1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-06-2015, 09:04 AM
  2. Dynamic Button based on Slide Bar Action
    By DM2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-10-2015, 04:13 PM
  3. [SOLVED] Copying Chart to Specific PowerPoint Slide
    By HabsFan89 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-09-2015, 02:03 PM
  4. [SOLVED] Changing the Chart Title automatically when a value in Slicer is selected
    By rv02 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 12-03-2014, 06:05 PM
  5. [SOLVED] Dynamic repeating order that needs to change based on specific criteria
    By rcoope02 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-14-2013, 11:30 AM
  6. Replies: 1
    Last Post: 04-02-2012, 03:57 PM
  7. Macros to copy chart from Excel into specific PPT Slide
    By undergraduate in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-03-2010, 12:00 PM

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