VBA for saving multiple pie charts

the_adam

New Member
Joined
Mar 23, 2011
Messages
1
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
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Watch MrExcel Video

Forum statistics

Threads
1,108,985
Messages
5,526,063
Members
409,685
Latest member
Davetom

This Week's Hot Topics

Top