Creating summary reports with charts & numbers from Excel data
Posted by Jaspal Jandu on August 04, 2001 11:03 AM
I have a country database in Excel which lists many economic (e.g. GDP, population etc.) variables per country (212 in total). The database is updated every quarter.
I would like to produce one page summaries for each country in a printer friendly format (i.e. a one page overview of Turkey, for example, would include: country name, population, a few charts showing GDP over the last five years etc). All the data required for each summary is in the database.
I tried to link the Excel data to a Word mailmerge document, and whilst this produced the 212 reports very quickly for fields containing names, it could not create new individual charts for each country (even using ODBC links).
Can I solve this problem solely in Excel??