Can I print every chart in a workbook without printing the tables easily?

[BDCanuck]

Hello all!

I have a workbook with about 45 sheets in it. Each sheet has a small pivot table (that I don't want to print) and a chart (that I do want to print).

If I select a chart one at a time, it prints nicely, but it takes a long time. If I print entire workbook, it prints all the little data tables with the charts. 

Is there a fast way to print all of the charts?

[#2 · Accepted solution]

@BDCanuck If the pivot table is small enough and the charts big enough, you could drag the charts on top of the pivot table, effectively hiding it. You'd need to do this 45 times of course, but then you're all set.

[#3]

Hmmm this is an odd but workable solution. Thanks!