How do I make a chart fit on one page?

How do I make a chart fit on one page?

Shrink a worksheet to fit on one page Select the Page tab in the Page Setup dialog box. Select Fit to under Scaling. To fit your document to print on one page, choose 1 page(s) wide by 1 tall in the Fit to boxes. Note: Excel will shrink your data to fit on the number of pages specified.

How do you AutoFit in Word?

Resize a column or table automatically with AutoFit

  1. Select your table.
  2. On the Layout tab, in the Cell Size group, click AutoFit.
  3. Do one of the following. To adjust column width automatically, click AutoFit Contents. To adjust table width automatically, click AutoFit Window.

How do you scale a graph in Word?

These steps allow you to scale the X axis:

  1. Select the X axis with the mouse.
  2. Choose Selected Axis from the Format menu. Microsoft Graph displays the Format Axis dialog box.
  3. Make sure the Scale tab is selected. (See Figure 1.)
  4. Modify the scale settings as desired.
  5. Click on OK.

How do I print to fit to scale in Word?

To change the scale of a Word document without adjusting its formatting, open the “File” menu, click “Print” and open the zoom option, which by default reads “1 Page Per Sheet.” Choose “Scale to Paper Size” and pick a new size.

How do you create a whole sheet in Excel?

Print a chart on a full page

  1. Click the chart that you want to print.
  2. On the Chart Design tab, click Move Chart.
  3. In the Move Chart dialog box, select New sheet, and click OK. Tip: To add titles, set axis options, add error bars, and other formatting, click the Chart Design tab.
  4. On the File menu, click Print.

How do I fit a chart in Excel?

Click the chart, and then drag the sizing handles to the size that you want. Click the chart, and then on the Format tab, under Size, enter the size in the Height and Width boxes.

How do I use AutoFit contents?

To use the feature, follow these steps:

  1. Select the entire table.
  2. Make sure the Layout tab of the ribbon is displayed.
  3. In the Cell Size group click AutoFit. Word displays a drop-down list of choices.
  4. Choose AutoFit Contents from the choices.

How do you use AutoFit?

Change the column width to automatically fit the contents (auto fit)

  1. Select the column or columns that you want to change.
  2. On the Home tab, in the Cells group, click Format.
  3. Under Cell Size, click AutoFit Column Width.

How do I change the axis scale in Word?

Click the chart, and then click the Chart Layout tab. Under Axes, click Axes > Vertical Axis, and then click the kind of axis label that you want.

How do I Format an axis in Word?

  1. Click anywhere in the chart. This displays the Chart Tools, adding the Design, Layout, and Format tabs.
  2. On the Format tab, in the Current Selection group, click the arrow in the Chart Elements box, and then click the axis that you want to select.

Where is fit to page in Word?

In “Table Tools” click the [Layout] tab > locate the “Cell Size” group and choose from of the following options:

  1. To fit the columns to the text (or page margins if cells are empty), click [AutoFit] > select “AutoFit Contents.”
  2. To fit the table to the text, click [AutoFit] > select “AutoFit Window.”

How do you fit to page in Word 2010?

“Shrink to Fit” changes the font size and margins to make the document fit on one page. In Microsoft Word 2007 and 2010, go to “Print,” “Print Preview” and then “Shrink to Fit” under the “Preview” option.