Copy a chart

In Microsoft Office Excel, you can copy an existing chart to another worksheet or chart sheet, a different workbook, or to another location on the same worksheet. To copy a chart in the same worksheet, you can drag the chart by using the mouse.

You can also copy an Excel chart to other Microsoft Office programs, such as PowerPoint and Word. If needed, you can copy a static picture of a chart to another workbook location or to a document that you created by using another program.

In this article

Copy a chart to another workbook location

Copy a chart by using the mouse

Copy a chart to a PowerPoint presentation

Copy a chart to a Word document

Copy a picture of a chart to another workbook location or document

Copy a chart to another workbook location

  1. In Excel, select the chart that you want to copy.

  2. On the Home tab, in the Clipboard group, click Copy Button image.

    The Clipboard group on the Home tab

    Keyboard shortcut  You can also press CTRL+C.

  3. Click the worksheet where you want to paste the copied chart.

    Tip   To paste the copied chart in another workbook, open that workbook, and then click the worksheet or chart sheet where you want to paste the copied chart.

  4. On the Home tab, in the Clipboard group, click Paste.

    Keyboard shortcut  You can also press CTRL+V.

  5. If you paste a chart on a worksheet, click Paste Options Button image next to the chart, and then do one of the following:

    • To paste the chart in its original format, click Keep Source Formatting.

    • To paste the chart and format it by using the document theme that is applied to the presentation, click Use Destination Theme.

      Note   If you copied a chart from another program, different paste options will be available on the worksheet, depending on the program that you copied from.

Tip   You can also paste a copied chart as a static picture in PNG format (.png). On the Home tab, in the Clipboard group, click the arrow below Paste, click As Picture, and then click Paste as Picture. A chart that is pasted as a picture does not update when the source data changes. Also, a chart that is pasted as a picture might have a reduced print quality.

Top of Page

Copy a chart by using the mouse

  1. Right-click the chart that you want to copy, and then drag it to the location that you want.

  2. After you release the mouse, click Copy Here.

Top of Page

Copy a chart to a PowerPoint presentation

  1. In Excel, select the chart that you want to copy to a PowerPoint presentation.

  2. On the Home tab, in the Clipboard group, click Copy Button image.

    The Clipboard group on the Home tab

    Keyboard shortcut  You can also press CTRL+C.

  3. Click in the PowerPoint presentation where you want to paste the copied chart.

  4. On the Home tab, in the Clipboard group, click Paste.

    Keyboard shortcut  You can also press CTRL+V.

  5. Click Paste Options Button image next to the chart, and then do one of the following:

    • To paste the chart with a link to its source data, click Chart (linked to Excel data).

    • To paste the chart and to include access to the whole workbook in the presentation, click Excel Chart (entire workbook).

    • To paste the chart as a static picture, click Paste as Picture.

    • To paste the chart in its original format, click Keep Source Formatting.

    • To paste the chart and format it by using the document theme that is applied to the presentation, click Use Destination Theme.

Tips

  • To paste a chart in another format, click the arrow on the Paste button, and then click Paste Special. In the As list, select the format that you want to use.

    • To paste a chart as a static picture, click any Picture or Bitmap option. Picture format generally provides better display quality than Bitmap format.

    • Click Microsoft Office Graphic Object to paste a chart as a graphic object that can be edited by using the chart tools in PowerPoint. This option is not available when you are using Compatibility Mode in PowerPoint.

    • Click Microsoft Office Excel Chart Object, and then click Paste link to paste a chart as an embedded object that is linked to the source data of the original Excel chart so that it is updated when the chart data changes. Microsoft Office Excel Chart Object is not available when you are using Compatibility Mode in PowerPoint.

    • To paste the chart as an Object Linking and Embedding (OLE) PowerPoint program icon (instead of pasting the actual chart) into a presentation, click Microsoft Office Excel Chart Object, and then select the Display as icon check box. You can click the icon to open the application, and then view the chart. Microsoft Office Excel Chart Object is not available when you are using Compatibility Mode in PowerPoint.

  • You can also create a Microsoft Office Excel 2007 chart directly in Microsoft Office PowerPoint 2007 by clicking the Chart button on the Ribbon (Insert tab, Illustrations group), and then by using the chart tools to modify or format the chart. Charts that you create in PowerPoint will be embedded in the PowerPoint presentation, and their source data is stored in an Excel worksheet that is incorporated in the PowerPoint file.

    Note   The Ribbon is a component of the Microsoft Office Fluent user interface.

Top of Page

Copy a chart to a Word document

  1. In Excel, select the chart that you want to copy to a Word document.

  2. On the Home tab, in the Clipboard group, click Copy Button image.

    The Clipboard group on the Home tab

    Keyboard shortcut  You can also press CTRL+C.

  3. In the Word document, click where you want to paste the copied chart.

  4. On the Home tab, in the Clipboard group, click Paste.

    Keyboard shortcut  You can also press CTRL+V.

  5. Click Paste Options Button image next to the chart, and then do one of the following:

    • To paste the chart with a link to its source data, click Chart (linked to Excel data).

    • To paste the chart and to include access to the whole workbook in the document, click Excel Chart (entire workbook).

    • To paste the chart as a static picture, click Paste as Picture.

    • To paste the chart in its original format, click Keep Source Formatting.

    • To paste the chart and format it by using the document theme that is applied to the document, click Use Destination Theme.

      Note   The Paste Options button is not available when you paste a chart in a document that is opened in Compatibility Mode in Word. In Compatibility Mode, the chart is pasted as a static picture.

Top of Page

Copy a picture of a chart to another workbook location or document

  1. In Excel, select the chart that you want to copy as a picture.

  2. On the Home tab, in the Clipboard group, click the arrow below Paste, click As Picture, and then click Copy as Picture.

    The Clipboard group on the Home tab

  3. In the Copy Picture dialog box, do the following:

    • Under Appearance, click the option that you want to use.

    • Under Format, click the option that you want to use.

      Tip   For the best picture quality, make sure that the As shown on screen and Picture options are selected. However, to preserve picture quality, items that you copy by using the As shown on screen and Picture options are always pasted at 100% of their original size. For example, if you scale a worksheet at 75%, a copied item from that worksheet may appear larger because it is pasted at actual size.

  4. Click OK.

  5. On a worksheet or chart sheet, click where you want to paste the picture.

    Tip   To paste the picture in a document of another program, open that document, and then use the Paste commands that are available in that program.

  6. On the Home tab, in the Clipboard group, click Paste Button image.

    Keyboard shortcut  You can also press CTRL+V.

  7. If you want to format the picture, do the following:

    1. Select the picture.

      Tip   This displays the Picture Tools, adding the Format tab.

    2. On the Format tab, in the Adjust group, Picture Style group, Arrange group, or Size group, and then click the formatting options that you want.

Top of Page

Applies To: Excel 2007



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language