Microsoft Excel 2007/2008: Charting Extras (Win/Mac)

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.

• Printing Chart and Worksheet Data
• Copying Charts to Word

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

Copying 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 COPY
   OR
   Right click the chart » select Copy
   Macintosh: On the Command bar, click COPY
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 theon the PASTE button » select Paste Special...
   Macintosh: In Word, from the Edit menu, select Paste Special...
   The Paste Special dialog box appears.
   
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.

Make sure to let me know in the comments below or on our Facebook page how you've got with it or Do you have any questions