This browser does not support basic Web standards, preventing the display of our site's intended design. May we suggest that you upgrade your browser?

Microsoft Excel 2007/2008

Charting Extras

The extra charting features offered in Excel 2007/2008 can be very useful during the charting process. In this document, these extras include printing options and how to copy charts to Microsoft Word.

return to topPrinting Chart and Worksheet Data

Within Excel, you can print entire worksheets, selected data, or the chart alone. For more information about printing in Excel, refer to Printing Basics.

Printing the Data and Chart

If you need to print your chart and data together, you can reposition the chart next to or below the data so that both fit on one page. Or, you can use Page Break Preview to see what will be printed on one page. For more information, refer to Using Printing Options.

  1. Place the insertion point anywhere within the worksheet to be printed except within the chart

  2. Windows: Click the OFFICE BUTTONOffice Button» select Print
    Macintosh: From the File menu, select Print...
    The Print dialog box appears.

  3. In the Print what section, verify that Active sheet(s) is selected

  4. Click OK
    The selected worksheet is printed along with the chart.

Printing Only the Chart

This option allows you to print only the chart, rather than the data table or the entire worksheet.

NOTE: When printing only a chart, Excel will resize the chart to fit the page.

Windows:

  1. Click the chart you want to print

  2. Click the OFFICE BUTTONOffice Button» select Print
    The Print dialog box appears.

  3. In the Print what section, verify that Selected Chart is selected

  4. Click OK
    The chart is printed.

Macintosh:

  1. Click the chart you want to print

  2. Move and position the chart into a blank worksheet

  3. From the File menu, select Print...
    The Print dialog box appears.

  4. In the Pages section, select From

  5. In the From text box, type the worksheet number that the chart is in
    EXAMPLE: If the chart is in worksheet 2, type [2]

  6. In the to text box, type the worksheet number that the chart is in
    EXAMPLE: If the chart is in worksheet 2, type [2]

  7. Click PRINT
    The chart is printed.

return to topCopying Charts to Word

When you copy a chart to Word, you can create a link so that if the worksheet is updated, the Word chart will also be updated.

  1. In Excel, select the chart to be copied

  2. Windows: On the Home command tab, in the Clipboard group, click COPYCopy button
    OR
    Right click the chart » select CopyCopy selection
    Macintosh: On the Command bar, click COPYCopy button

  3. Open the Word document to which you will add the chart

  4. In the Word document, place the insertion point where the chart will be pasted

  5. Windows: In Word, on the Home command tab, in the Clipboard group, click theDown arrowon the PASTE button » select Paste Special...
    Macintosh: In Word, from the Edit menu, select Paste Special...
    The Paste Special dialog box appears.
    Paste Special dialog box

  6. To paste the chart with a link
    1. Select Paste Link:
    2. Windows: Select Microsoft Office Excel Worksheet Object
      Macintosh: Select Microsoft Excel Chart Object
      NOTE: To paste with linking means that when changes are made to the original source chart, the pasted chart will be updated.

  7. To paste the chart without a link
    1. Select Paste
    2. Windows: Select Microsoft Office Excel Worksheet Object
      Macintosh: Select Microsoft Excel Chart Object
      NOTE: To paste without linking means that when changes are made to the original source chart, the pasted chart will not be updated.

  8. Click OK
    The chart is pasted.

Excellence. Our Measure. Our Motto. Our Goal.