Printing Mulitple Charts on One Page 1

[Santee]

Help. How do you do this in Excel XP.

 

[luceze]

Where are the charts located?

 

[Santee]

The charts are in the same workbook just on different sheets. The data is on one worksheet. We created 4 charts from the data sheet. I tried what Anna2222 suggested but it still didn't work.

 

[KenWright]

Insert a new sheet specifically for this. Then just select, copy and then paste each of the charts onto that sheet. All the ranges will still refer back to the original source data for each of the charts. You can now resize each of the charts as you wish, as well putting any other data tables on that you might want. Then just select the whol area and print 'Fit to One Page'. You might have to play about with chart sizes to achieve a nice effect. Once it is set, you can then change data on each of your source charts, and the summary sheet with all teh copies on will automatically update.

It doesn't matter if your source charts are Chart Sheets as opposed to objects on a sheet, just select them and do edit / Copy.

Regards
Ken.......

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------

 

[Santee]

Thanks KenWright that worked!

 

[KenWright]

My pleasure

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------