Copying Graphics from Excel

PM Milestone Project Management Templates

PM Milestone 7000 Project Management Templates

Get Instant Access

You can copy an Excel graph and paste it into certain areas of Microsoft Project as a picture. You can even copy Excel worksheet cells, and instead of pasting those cells into table cells, you can paste them as a picture in Microsoft Project.

To paste Excel information as a static picture, do the following:

1 In Excel, select the chart or other data you want to insert as a picture in Microsoft Project.

2 On the Standard toolbar, click Copy.

3 In your Microsoft Project file, display the location where you want to place the picture. The following specific locations in Microsoft Project can accept pictures:

■ Chart area of a Gantt chart

■ Notes tab on the Task Information, Resource Information, or Assignment Information dialog box

■ Objects box in the Task Form or Resource Form

■ Notes box in the Task Form or Resource Form

■ Header, footer, or legend of a printable view or report 4 Click Edit, Paste Special.

The Paste Special dialog box appears (see Figure 17-2).

Figure 17-2. Use the Paste Special dialog box to specify that you want to insert the Excel information as a picture.

5 Select the Paste option.

6 In the As box, click Picture or Picture (Bitmap).

This option ensures that the data, whether it's a chart or a set of worksheet cells, is pasted as a graphic rather than as an embedded graphic or straight text.

Note If the Paste Special command is not available for the location where you want to paste the picture, press Ctrl+V instead.

7 Click OK.

The new picture is pasted in Microsoft Project at your selected location (see Figure 17-3).

Excel chart picture in the

Gantt Chart

Excel chart picture in the

Gantt Chart

Figure 17-3. The Excel information appears as a picture in your selected Microsoft Project location.

Figure 17-3. The Excel information appears as a picture in your selected Microsoft Project location.

Although static pictures look like embedded objects, they cannot be opened and edited. However, they can be moved and resized.

For more information about embedded objects, see "Embedding an Excel Object in Project" later in this chapter on page 510.

Was this article helpful?

0 0
Project Management Made Easy

Project Management Made Easy

What you need to know about… Project Management Made Easy! Project management consists of more than just a large building project and can encompass small projects as well. No matter what the size of your project, you need to have some sort of project management. How you manage your project has everything to do with its outcome.

Get My Free Ebook


Post a comment