Assistance w/PieChartMailMerge

[Joe Mac]

All...

I've been trying to get this VBA code to work with my data... I've pulled
down the sample data, letters and "How to" instructions, but can't get the
utility to work with my data... I've been meticulous in following the steps,
but each time I run the macro, the datasheet does not populate with the data
that I have entered... I've stepped through the macro and I know that the
data is being read, as I can see the rows incrementally being Merged in
parallel table cells and I can see the data being trimmed of word table
characters in the Locals window... the challenge is that the datasheet for
the graph object is not being populated in the merged documents and the main
merge document object is getting overwritten so that no graph appears in it
after the macro runs... I'm using Word 2003 & the MS Graph object library is
v11.0
Any thoughts?

 

[Joe Mac]

Walked away for a bit and cam back at it and figured it out... the datasheet
didn't like the fact that I had a "$" in front of the data consequently the
datavalue was set to "0"... eliminated the "$" and all worked fine... I
also changed the chartType from the xlPie to XL3DPie and all worked fine...

Sorry for the duplicate entries, I received an error when originally posting
to the board