Microsoft Excel XP/X
Charting Extras
Extra features offered by Excel can be very useful to you during different stages of your project. Excel contains options which allow you to copy and paste charts, print charts and worksheets, and copy charts into Word.
This document covers:
Copying and Pasting Charts
If you are going to be creating multiple charts for the same presentation/report that contain similar data, you can reduce your effort by creating the first chart and then copying that chart. Each time you paste the chart, you will update the ranges and titles for the chart for the different data. This can help improve the consistency between various charts, along with saving you time!
-
Select the chart to be copied
-
From the Edit menu, select Copy
OR
On the Standard toolbar, click COPY
or 
-
Place the cursor where you would like chart to be
-
From the Edit menu, select Paste
OR
On the Standard toolbar, click PASTE
or 
Printing Chart and Worksheet Data
When printing the chart and worksheet information, you will need to first arrange the elements appropriately on your worksheet (all the information will have to be on the same page).
Printing Selected Data
-
Select the range to be printed
-
From the File menu, select Print...
The Print dialog box appears. -
Under Print what, select Selection
-
Windows: Click OK
Macintosh: Click PRINT
Printing Active Worksheet(s)
This option will print entire the worksheet(s)
-
From the File menu, select Print...
The Print dialog box appears. -
Under Print what, select Active sheet(s)
-
Windows: Click OK
Macintosh: Click PRINT
Printing Chart Only
-
Click your chart to select it
-
From the File menu, select Print...
The Print dialog box appears. -
Windows: Click OK
Macintosh: Click PRINT
Copying Charts to Word
Adding charts to Word is a feature available because of the integration between the programs in the Microsoft Office suite. When you copy the chart to Word, you can create a link so if the worksheet is updated, the Word chart will also be updated.
-
Select the chart to be copied
-
From the Edit menu, select Copy
OR
On the Standard toolbar, click COPY or -
Open Word
-
Open the document to which you want the chart copied
-
Click the insertion point where the chart should appear
-
From the Word 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
NOTE: To paste without linking means data changes will not be updated on the chart that was copied when the original has been changed. To paste with linking will allow the pasted chart to be updated as changes to the original are made. -
Click OK
