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
Bookmarks