Set up a chart for printing

Depending on whether a chart is embedded (embedded chart: A chart that is placed on a worksheet rather than on a separate chart sheet. Embedded charts are beneficial when you want to view or print a chart or a PivotChart report with its source data or other information in a worksheet.) or on a separate chart sheet (chart sheet: A sheet in a workbook that contains only a chart. A chart sheet is beneficial when you want to view a chart or a PivotChart report separately from worksheet data or a PivotTable report.), you can choose specific print options.

Before you print a worksheet (worksheet: The primary document that you use in Excel to store and work with data. Also called a spreadsheet. A worksheet consists of cells that are organized into columns and rows; a worksheet is always stored in a workbook.) with an embedded chart, you can adjust where the chart will print on the page by sizing and moving it in page break view (page break preview: Worksheet view that displays the areas to be printed and the locations of page breaks. The area to be printed is displayed in white, automatic page breaks appear as dashed lines, and manual page breaks appear as solid lines.). You can also print an embedded chart without the worksheet data.

Before you print a chart sheet, you can size and scale the chart area, specify how it should be placed on the printed page, and then view it in the preview window.

What do you want to do?

Adjust and print an embedded chart

Print an embedded chart without the worksheet data

Adjust and print a chart sheet

Adjust and print an embedded chart

  1. Click the worksheet that contains the embedded chart.
  2. On the View menu, click Page Break Preview.
  3. Drag the chart to a preferred location on the printed page.
  4. On the View menu, click Normal.
  5. On the File menu, click Print.

 Note   If a worksheet contains more than one embedded chart, you may be able to print them on one page by reducing the size of the charts.

Top of Page Top of Page

Print an embedded chart without the worksheet data

  1. On the worksheet, click the embedded chart that you want to print.

 Note   You can print only one embedded chart per page.

  1. Click Page Setup on the File menu.
  2. On the Chart tab, under Printed chart size, click Use full page, Scale to fit page, or Custom.

If you click Custom, and then click OK, you can drag the chart area to the location and size that you want.

  1. On the File menu, click Print.

 Note   Under Print what, Selected Chart will be selected.

 Tip   You can also use the mouse to move and size the chart area of an embedded chart before you print the chart.

Top of Page Top of Page

Adjust and print a chart sheet

  1. Click the chart sheet (chart sheet: A sheet in a workbook that contains only a chart. A chart sheet is beneficial when you want to view a chart or a PivotChart report separately from worksheet data or a PivotTable report.) that you want to print.
  2. On the File menu, click Page Setup.
  3. On the Chart tab, under Printed chart size, click Use full page, Scale to fit page, or Custom.

If you click Custom, and then click OK, you can drag the chart area to the location and size that you want.

  1. On the File menu, click Print.

Top of Page Top of Page

 
 
Applies to:
Excel 2003