How to scale chart to print on a full page

I have just switched from Excel 2003 to Excel 2010. In excel 2003 I can select a chart then go to the print preview page then select SETUP which brings up the page setup window. In that window under the CHART tab there are several options to choose from for sizing the chart to the printed page. Choosing the "Use full page" option will scale the chart to fill the printed page within the margins. In Excel 2010 the CHART tab does not contain any print sizing options. Where do I find these printing options in Excel 2010?

Thanks for any help.
David

Thanks for the help but my version does not seem to scale the chart in both x and y directions like it did in Excel 2003. If I make the chart tall in the spreadsheet then go to print it the vertical scale fits the sheet but the width is not scaled to fit the width of the printed sheet and if I make the chart very wide in the spreadsheet then try to print it the width is scaled to fit the page but the vertical dimension is not scaled to fit. To me it sounds like there is an aspect ratio issue. Is there a setting somewhere that tells Excel to print without adjusting the aspect ratio?

Thanks for the help.
David

Originally Posted by Numcruncher1

Thanks for the help but my version does not seem to scale the chart in both x and y directions like it did in Excel 2003. If I make the chart tall in the spreadsheet then go to print it the vertical scale fits the sheet but the width is not scaled to fit the width of the printed sheet and if I make the chart very wide in the spreadsheet then try to print it the width is scaled to fit the page but the vertical dimension is not scaled to fit. To me it sounds like there is an aspect ratio issue. Is there a setting somewhere that tells Excel to print without adjusting the aspect ratio?

Thanks for the help.
David

Search for this forum thread:
"Printing a Chart on 8.5 x 14 (Legal size) paper" and look at post #9. Of the three methods I describe, two will allow you to adjust either the width or height independent of the other. This works in both Excel 2007 & 2010.

Harry

Thanks BEX1210. That will work until I get a newer version of Excel. I will mark this as solved.

David