+ Reply to Thread
Results 1 to 6 of 6

Copy picture from Excel to Power point presentation

  1. #1
    Registered User
    Join Date
    02-17-2010
    Location
    Brisbane Australia
    MS-Off Ver
    Excel 2016
    Posts
    45

    Copy picture from Excel to Power point presentation

    Hi all,

    I would like some help here before I go mental!

    I have a number of separate files each with a dashboard/scorecard. The said scorecard has a transparent - ish picture (a specific report template picture) with a number of KPI's that are being updated off a pivot table. I would like to export the whole picture as JPG (or whichever format is suitable) with the updated numbers in it, in a Power Point Presentation.

    The problem I have is that I cant seem to find the best way to do it. Looks like the darn thing selects the whole range...

    Any help would be greatly appreciated!


    Please Login or Register  to view this content.

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    2013 / 2016 / 365
    Posts
    7,081

    Re: Copy picture from Excel to Power point presentation

    See if this helps.
    Attached Files Attached Files
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Registered User
    Join Date
    02-17-2010
    Location
    Brisbane Australia
    MS-Off Ver
    Excel 2016
    Posts
    45

    Re: Copy picture from Excel to Power point presentation

    @dflak Look like is working but...it does not take the actual numbers in the text boxes attached to the picture (not a chart or table). it only takes the picture (which plays a background role only)

    EDIT: Actually I figured it out.

    Is there a way to run through Pivot table filter and export each outcome to PP?
    Last edited by hawk77EF; 05-17-2016 at 12:26 AM.

  4. #4
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    2013 / 2016 / 365
    Posts
    7,081

    Re: Copy picture from Excel to Power point presentation

    This really should have been asked as a separate question, but I’m not going to make you go through that – but do remember for the next time.

    The simplest way to change a pivot table filter is to use VB code to write the value into the cell that contains the filter – this works provided the value is string data and you provide a valid value.

    You can pass dates, but they must be in string format, and they must be of the same format as the pivot table is expecting. In other words if the pivot table is using “mm/dd/yy” and you pass “mm/dd/yyyy” it’s going to think it’s a different value.

    This technique doesn’t work if you want to select multiple values, but you can pass the string “(All)” and it will work.

    In the attached spreadsheet. The pivot table whose filter we want to change is in columns F:G. The pivot table filter is cell G1.

    I have a second pivot table in column I. This table gives me a unique list of the months – each of which is a valid value for the pivot table. Pivot tables are the easiest means of getting a unique list of values.

    I overlaid the pivot table with a named dynamic range: MyMonths =OFFSET(Sheet1!$I$2,0,0,COUNTA(Sheet1!$I:$I)-1,1)

    I run through this list in the code and set cell G1 to each value in turn.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    02-17-2010
    Location
    Brisbane Australia
    MS-Off Ver
    Excel 2016
    Posts
    45

    Re: Copy picture from Excel to Power point presentation

    I will explain first the way I have my dashboard set up:
    1. First I have a picture that is used as background in Scorecard sheet
    2. Multiple text boxes that contain figures off a pivot table on a "Pivot" sheet
    3. On the Pivot sheet I have two pivot tables using the same data source but for two different years (2015 full year KPI, and 2016 monthly KPI), but different cities (in a separate slicer) .
    4. My Objective is to have the macro run through each city option (in a slicer or not - I have a slicer to do it manually), populate the dashboard (it will do it anyways) and export the scorecards as picture in a Powerpoint presentation on different slides.
    At the moment for some reason it exports 8 of them in line for the first city/port.
    Last edited by hawk77EF; 05-18-2016 at 12:40 AM.

  6. #6
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    2013 / 2016 / 365
    Posts
    7,081

    Re: Copy picture from Excel to Power point presentation

    Without the workbook itself, I can only offer a general solution.

    First of all it is easier to populate the two filters using VBA rather than to use the slicer. To use the slicer you would have to loop to turn on everything and then loop to turn off all but what you want to see. This has to do with the fact that Pivot table filters have to have *something* selected and it is possible that you can turn off whatever is selected before turning on what you do want to select.

    As far a copying the ranges, I'm not quite sure what your problem is. If the issue is due to the changing size of the pivot table, you might want to overlay the data you want to copy with a named dynamic range. Named dynamic ranges should work with the pivot table "map." Use the name instead of the coordinates.

+ 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. macro to open AND run a power point presentation.
    By ledelatorre in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-21-2016, 11:53 AM
  2. Replies: 2
    Last Post: 02-17-2015, 12:39 PM
  3. power point active x buttons working only on presentation mode
    By var in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-03-2015, 01:01 PM
  4. [SOLVED] How to set a power point presentation as an object (from the excel vba editor)
    By Jonas1503 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-09-2014, 08:08 AM
  5. Excel Charts linked to Power Point Presentation
    By hattrick_123a in forum Excel General
    Replies: 2
    Last Post: 07-07-2011, 12:37 AM
  6. copy data from excel to power point
    By iscar_marius in forum Excel General
    Replies: 8
    Last Post: 02-09-2009, 08:20 AM
  7. Copy multiple charts from Excel to Power Point
    By Genef in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-01-2005, 10:07 PM

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