Pivot table/graph - mass printing

[RussChilds]

Hi all,

I have a graph that links to a pivot table. The graph shows data from students. We have 225 students. Is there a way of printing the individual graphs for each student automatically without having to change the filter each time and pressing print 225 times?

Many thanks in advance!

Russ

 

[Gerald Higgins]

Do you REALLY want to PRINT 225 different graphs ? Think of the trees !

But if you DO really want to do this, this will be do-able using VBA, and specifically by using a For Loop, to loop through all your individual students.
I'm not an expert on VBA, but if you try searching on this board you will find plenty of examples of this kind of thing.