Set up a chart for printing

Microsoft Office Excel 2003

previous page next page
  • Click the worksheet outside of the chart area.
  • Click Page Break Preview on the View menu.

    • 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.

    1. Click the tab for the chart sheet.
    2. Click Page Setup on the File menu.
    3. Select the options you want on the Chart tab.

    Note  To move and size the chart area of a chart sheet by using the mouse, you must click Custom on the Chart tab and then click OK to return to the chart sheet.

    ShowTips


    • To print an embedded chart without its associated worksheet data, click the embedded chart to select it, and then follow the instructions for chart sheets. You can move and size the chart area of an embedded chart without using the Custom option on the Chart tab (File menu, Page Setup command).
    • You can hide the display of field buttons in a PivotChart report before printing. Click PivotChart on the PivotTable toolbar, and then click Hide PivotChart Field Buttons.
    previous page start next page