+ Reply to Thread
Results 1 to 3 of 3

Run Customised Report - Excel linked to Powerpoint

  1. #1
    Registered User
    Join Date
    05-28-2016
    Location
    Chelmsford
    MS-Off Ver
    2016
    Posts
    1

    Run Customised Report - Excel linked to Powerpoint

    Hi,

    I've got produced a report in Excel based on a survey of about 100 different organisations.

    The raw data is in Excel, a set of tables and from the tables I've created a series of stacked bar charts for each of the questions from the survey.

    The bar charts basically show, for each question, how many of the organisations have put a particular answer e.g. 20 'strongly agree', '50 agree'.

    The charts from Excel are pasted into powerpoint (such that Powerpoint will update should the figures change).

    However, what I want to do is to create a set of customisable powerpoint presentations for each of the 100 customers (which I will pdf) which not only show the aggregated results but also indicate somehow what each of the organisations put as a response.

    So essentially you'd have a report for customer 1 which would list all the questions using the stacked bar charts but also be able to remind people what they put as a response. And then another report for customer 2 and so on.

    Two questions:

    - Is there any way of showing this as an overlay on the stacked bar graph (or is there a better way of showing this)?

    - Is there any way of being able to run the set of powerpoint reports automatically?

    Hope that makes sense - let me know if not!


    Mark
    Attached Images Attached Images

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

    Re: Run Customised Report - Excel linked to Powerpoint

    The attachment might help. It is an example of how to substitute fixed text in a "template" and how to insert charts and tables onto blank pages. I'm assuming that your "template" file is the same for all organizations and you just want to substitute the appropriate chart on the appropriate slide.

    The spreadsheet in the attachment does this using a table that contains a "map" showing where the information is located in Excel, what page it has to go to in PowerPoint, and how to size an position what is inserted into PowerPoint.

    You will have to modify the code so that the output file and the "where do I get the Excel chart" reflects the organization name. This could most likely be done with a formula. In fact you might even be able to wrap the code in a loop to do each organization automatically.
    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
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,908

    Re: Run Customised Report - Excel linked to Powerpoint

    Just noticed the location. I used to live in Chelmsford.

+ 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. Duplicate a linked excel and powerpoint
    By Kajsa in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-02-2013, 07:31 AM
  2. Replies: 3
    Last Post: 07-31-2012, 05:19 PM
  3. Linked Excel to PowerPoint Issue
    By boogie87 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-20-2011, 07:10 AM
  4. Data input in powerpoint to select data in excel and report back to powerpoint
    By daveybright in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-10-2009, 09:54 PM
  5. Linked Excel charts in powerpoint
    By Spencinator in forum Excel General
    Replies: 3
    Last Post: 07-21-2009, 03:17 AM
  6. Excel-linked Powerpoint presentations
    By TheRetroChief in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-06-2009, 07:42 AM
  7. Linked Excel to Powerpoint
    By Sionos in forum Excel General
    Replies: 1
    Last Post: 08-31-2007, 03:43 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