Hi all,
I'm trying to find a way to creating pie charts for use in a mail merge, assuming it's going to require some VBA coding but I'm not too sure where to begin!
Basically I need to create a chart for each of about 600 rows of data, the bit for the chart is just giving a total of subjects above/on/below target for each student in a school. Then each chart needs saving as a separate file, taking its filename from a unique number stored in one of the other columns so that I can link to it in the mail merge. I'm completely new to using VBA/macros so any help would be appreciated
Adam
I'm trying to find a way to creating pie charts for use in a mail merge, assuming it's going to require some VBA coding but I'm not too sure where to begin!
Basically I need to create a chart for each of about 600 rows of data, the bit for the chart is just giving a total of subjects above/on/below target for each student in a school. Then each chart needs saving as a separate file, taking its filename from a unique number stored in one of the other columns so that I can link to it in the mail merge. I'm completely new to using VBA/macros so any help would be appreciated
Adam
