Microsoft Office Tutorials and References
In Depth Information
Mail Merge: Merging with a Chart
Figure 63 – Chart with Legend
In both cases, the first row contains the legend text for the chart.
Tip: Because it simply fills the datasheet of an MS Graph object that is inserted and formatted,
the macro solution can be used with any kind of chart.
Follow these steps:
1. Save the data document and substitute its name for the code line Const
2. Set up the main merge document as a form letter in the normal fashion.
Use Insert | Object to insert a Microsoft Graph Chart. Choose the type
of chart you want and format it as desired. The macro changes only the
data in the data sheet. Select the chart, then over Insert | Bookmark,
insert a bookmark named PieChart.