Microsoft Excel 2003/2004
Charting Extras
Extra charting features offered by Excel can be very useful during the different stages of your project. Some of these options include printing charts and data and copying charts into 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
You can position the chart next to or below the data, so that both fit on one page. You can use Page Break Preview to see what will be printed on one page. For more information, refer to Using Printing Options: Using Page Break Preview. Once you are satisfied with what will be printed, use the following instructions:
-
Place the insertion point within the worksheet to be printed except within the chart
-
From the File menu, select Print...
The Print dialog box appears. -
In the Print what section, verify that Active sheet(s) is selected
-
Windows: Click OK
Macintosh: Click PRINT
The selected worksheet is printed
Printing Only the Chart
This option allows you to print only the chart, rather than the data table or the entire worksheet.
-
Click to select the desired chart
-
From the File menu, select Print...
The Print dialog box appears. -
Windows: In the Print what section, verify that Selected Chart is selected
Macintosh: In the Print what section, verify that Active Chart is selected -
Windows: Click OK
Macintosh: Click PRINT
The selected chart is printed.
Copying Charts to Word
Adding charts to Word is a feature available due to the integration between Microsoft Office programs. 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.
-
Select the chart to be copied to Word
-
From the Edit menu, select Copy
OR
On the Standard toolbar, click COPY
The chart is copied. -
Open the Word document to which the chart will be copied
-
Place the insertion point where the chart should be pasted
-
In Word, from the Edit menu, select Paste Special...
The Paste Special dialog box appears. -
To add the chart as a link, select Paste Link
To add the chart without a link, select Paste
NOTES:
To paste with linking means that when changes are made to the original source chart, the pasted chart will be updated.
To paste without linking means when changes are made to the original source chart, the pasted chart will not be updated. -
Click OK
The chart is pasted to Word.
