Solved: Print Multiple Pivot Charts on Single Sheet

[pmorris]

Is it possible to print multiple pivot charts on a single sheet of paper.

I have 3 pivot charts (each in a seperate worksheet) that I need to print on a single sheet of paper. I have tried grouping the 3 sheets and selecting to print on 1 sheet in print properties, unfortunately the options to do this are removed.

Can anyone help please!!!

Paul

[grichey]

You could use a macro to copy the charts from sheets 1,2,3 to a new sheet 4 formatted as you like. Set Print Area and force to fit to 1 page in page setup.

That would be the easiest way if you're going to need to do it often.

[pmorris]

Thanks very much