+ Reply to Thread
Results 1 to 5 of 5

How to scale chart to print on a full page

  1. #1
    Registered User
    Join Date
    01-15-2016
    Location
    USA
    MS-Off Ver
    2010
    Posts
    12

    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

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Rocester, New York, USA
    MS-Off Ver
    Excel 2007:10
    Posts
    1,819

    Re: How to scale chart to print on a full page

    Select the chart so it is the active element.
    File Ribbon => Print
    "Active Area" should default to "Print Selected Chart"

    That will zoom the chart to fill the selected paper size in your other print options.
    Click the [* Add Reputation] Button to thank people for help!
    Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
    Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.

  3. #3
    Registered User
    Join Date
    01-15-2016
    Location
    USA
    MS-Off Ver
    2010
    Posts
    12

    Re: How to scale chart to print on a full page

    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

  4. #4
    Registered User
    Join Date
    03-05-2018
    Location
    Toledo, OH
    MS-Off Ver
    Office 2007
    Posts
    9

    Re: How to scale chart to print on a full page

    Quote Originally Posted by Numcruncher1 View Post
    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

  5. #5
    Registered User
    Join Date
    01-15-2016
    Location
    USA
    MS-Off Ver
    2010
    Posts
    12

    Re: How to scale chart to print on a full page

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

    David

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1