you might be better off with:
fName = activeworkbook.name
which puts the name of the current workbook (eg. book1.xls)into the variable fName. You could then put the value in a textbox on each graph.
regarding IRstuff's method, I do know that this option will not work on all versions of excel...