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

  1. In Excel, select the chart that you want to copy.
  2. On the Home tab, in the Clipboard group, click Copy Button image.

Excel Ribbon

Keyboard shortcut  You can also press CTRL+C.

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

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

Keyboard shortcut  You can also press CTRL+V.

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

Excel Ribbon

Keyboard shortcut  You can also press CTRL+C.

  1. Click in the PowerPoint presentation where you want to paste the copied chart.
  2. On the Home tab, in the Clipboard group, click Paste.

Keyboard shortcut  You can also press CTRL+V.

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

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

Top of Page 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.

Excel Ribbon

Keyboard shortcut  You can also press CTRL+C.

  1. In the Word document, click where you want to paste the copied chart.
  2. On the Home tab, in the Clipboard group, click Paste.

Keyboard shortcut  You can also press CTRL+V.

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

Excel Ribbon

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

  1. Click OK.
  2. 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.

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

Keyboard shortcut  You can also press CTRL+V.

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

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

  1. 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 Top of Page

 
 
Applies to:
Excel 2007