If you're willing to do 100 old-fashioned cuts-and-pastes, could be
easier to copy/paste one chart into Word and get it laid out how you
want, then repeat for the other hundred. With a bit of macro recording
and some find/replace you /might/ be able to make that a bit easier.
Peter Jamieson
http://tips.pjmsn.me.uk
Visit Londinium at
http://www.ralphwatson.tv
Matthew wrote:
On 18 Sep, 11:31, Peter Jamieson
wrote:
See the conversation at, e.g.
http://www.eggheadcafe.com/conversat...34640971&threa...
There may be better ways to do this that do not involve a merge (e.g.
build each chart in Excel programmatically and insert it into the output
document)
Peter Jamieson
http://tips.pjmsn.me.uk
Visit Londinium athttp://www.ralphwatson.tv
Matthew wrote:
I am running office 2007.
I have used merge loads of times on a basic level, getting the data
from XL and utting it into letters reports etc.
The question is can you use the data from the database to create a
chart for each record ?
Hope some one can help or point me in the right direction.
Matthew
Peter,
Thanks for responding!
I think having read the threads and searched around there is no easy
way and as I only have 100 odd reports I will do it the old fashioned
way. Get excell to print me all the charts and I will manualy stick
them in the reports. Should look nice with a 'special page' for the
reports I can se the boss going for that.
Regards
Matthew