How to Copy a Graph in Excel: Steps and Options

Charts & pivot tables · Updated November 20, 2026

To copy a graph (called a chart in Excel), click its outer border, press Ctrl+C, click where you want the copy, and press Ctrl+V. This creates a second chart you can move or resize. Before copying to another workbook, check that you can access the chart’s source data: a copied chart may continue to refer to the original workbook.

What You’ll Need

  • An Excel workbook containing the chart you want to copy. The instructions below are for Excel for Microsoft 365 on Windows.
  • For a copy in another workbook, have the destination workbook open. If you need the chart to work independently, also plan to copy its source data or reconnect it after pasting.
  • On a Mac, use Command+C and Command+V in place of Ctrl+C and Ctrl+V. Excel for the web supports basic chart copying, though some paste and chart-editing options differ from the desktop app.

Step-by-Step

  1. Open the workbook and locate the chart. Select the worksheet tab that contains the graph. If the chart is on its own chart sheet, select that sheet tab instead. Make sure you have the intended chart; if several charts look alike, check its title, labels, or the data it displays before copying.

  2. Select the chart itself. Click near the chart’s outside edge or on its border. Handles should appear around the chart, showing that the whole chart object is selected. If you see a blinking cursor in the chart title, or only one data point appears selected, press Esc once and click the outer border again. Copying the whole object is different from copying a title or data series within it.

  3. Copy the selected chart. Press Ctrl+C, or right-click the chart border and choose Copy. On a Mac, press Command+C or Control-click the border and choose Copy. A moving dotted outline may appear around the chart; that indicates it is on the clipboard, not that the chart has moved or disappeared.

  4. Choose where the copy should go. To duplicate the chart on the same worksheet, click a clear area away from the original. To place it on another worksheet in the same workbook, click that sheet’s tab and then click an open area. To use a different workbook, switch to it or open it, select the destination sheet, and click a suitable cell or blank area.

  5. Paste the chart. Press Ctrl+V, or right-click the destination and choose Paste. On a Mac, press Command+V. Excel adds a new chart object. If it lands over the original or another item, do not paste repeatedly; drag the new chart by its border to an open spot. You can undo an accidental paste with Ctrl+Z on Windows or Command+Z on Mac.

  6. Position and size the duplicate. Click the chart border and drag the chart to move it. Drag a corner handle to resize it while keeping its proportions; dragging a side handle changes its width or height. On a worksheet, the chart is a floating object above the cells, so it can cover cell contents without changing or deleting those cells.

  7. Check the chart’s data connection. A copied chart usually keeps the original chart’s data-series references. That is convenient for another view of the same data, but it means a copy on a different sheet or workbook may still depend on the original source. To inspect or adjust the source, select the chart and choose Chart Design > Select Data. Review the chart data range and the series entries; if needed, select a new range or edit the series so they point to the intended cells.

  8. Save and verify the result. Confirm that the duplicate has the expected title, labels, series, and values. If it is in another workbook, save that workbook and, if prompted, review any links to external data. Close and reopen the destination file if you want to check that the chart still displays correctly when the source workbook is not open.

To copy a chart as a picture instead: Select its border, choose Home > Paste > Paste Special, and select an available picture option, such as Picture or Picture (Enhanced Metafile). The exact choices depend on the Excel version and clipboard contents. A picture is useful for a report or slide, but it is no longer an editable chart and will not update when worksheet values change.

To duplicate an entire chart sheet: Right-click the chart sheet tab, choose Move or Copy, select where to place it, check Create a copy, and choose OK. This copies the chart sheet rather than placing a second chart on an existing worksheet. On a Mac, Control-click the tab if you do not have a right-click gesture.

Common Mistakes

  • Selecting a chart part instead of the whole chart. Clicking a title, legend, or data point selects only that component. The copy may then contain just the selected element or behave differently than expected. Look for handles around the entire chart before copying.

  • Assuming the copied chart has independent data. A chart is not a snapshot of its values by default. A duplicate often continues to use the same source cells, so edits to those cells can change both charts. Copy the source data and use Chart Design > Select Data to point the duplicate to the new range if you want it to show a different dataset.

  • Expecting a pasted picture to remain editable. Picture paste makes a visual copy, not a chart object. You cannot use Chart Design to change its series or chart type. Use ordinary Paste when you need a working chart.

  • Pasting over something important. Excel may place the new chart on top of the old chart or worksheet content. Check the destination before pasting, then move the duplicate by its border. If you cannot select it because objects overlap, use the Selection Pane from the Home tab’s Find & Select menu to choose the chart by name.

  • Copying a chart without checking external references. When you paste into another workbook, the chart may keep links to the source workbook. If that file is renamed, moved, or unavailable, the chart can show stale information or a link warning. Confirm the source range and save both files where appropriate.

Tips

  • Use ordinary copy and paste for a chart you may edit later. It preserves chart features such as titles, legend, formatting, and series better than a screenshot. You can usually edit the duplicate without affecting its formatting in the same way as an image would.

  • Keep the source cells close when organizing a workbook. If the chart and its data are on different sheets, consider copying both or documenting the source sheet. This makes it easier to find the data later and reduces confusion about why a chart changes.

  • Use a picture when appearance matters more than interaction. A picture is often a good choice for a fixed report, email, or document where readers should not alter the chart. For a document in another Office app, you can also paste the chart normally and choose a linking or embedding option if the paste options offered by that app suit your needs.

  • Align duplicates deliberately. Turn on worksheet gridlines if they are hidden, then use the cell grid as a visual guide when positioning charts. Avoid resizing from a side handle if you want to preserve the chart’s proportions.

  • Rename chart sheets and organize chart objects. Clear sheet names and descriptive chart titles make it easier to identify the right item when copying. If several objects overlap, Home > Find & Select > Selection Pane can help you select and rename objects.

Troubleshooting

  • Nothing happens when you press Ctrl+C. First click the chart’s outer edge until the complete chart is selected, then try the shortcut again. If the worksheet is protected or you are editing text in a cell or chart title, finish or cancel that action and select the chart. You can also use the chart’s right-click menu and choose Copy.

  • The chart does not paste where expected. Make sure you have activated the destination worksheet or workbook before pressing Ctrl+V. Click an open area, not inside a cell’s formula bar or an editing field. If you see the copy outline but no pasted chart, try right-clicking the destination and choosing Paste, or use the Home tab’s Paste command.

  • The chart changes when the original data changes. This is usually expected when both charts refer to the same cells. Select the duplicate, choose Chart Design > Select Data, and set its chart data range or individual series to the new cells. If the source data is in another workbook, make sure the intended workbook is open and that you have selected the correct range.

  • The chart looks blank or shows an error after moving it to another workbook. Check whether the chart is linked to a source workbook that is closed, moved, or renamed. Reopen the source file, then inspect Chart Design > Select Data. If you need the destination workbook to stand alone, copy the source data into it and update the chart’s data range to those local cells.

  • You cannot find the pasted chart. It may be behind another object, outside the visible worksheet area, or on a different sheet. Check the sheet tabs and open Home > Find & Select > Selection Pane to locate the chart object. If needed, select it in the pane and move it back into view.

  • Paste Special does not show a picture option. Copy the chart again by selecting its outer border, then open Home > Paste > Paste Special immediately at the destination. Available picture formats can vary by Excel version and clipboard state. If the option remains unavailable, use a screenshot tool or paste the chart normally and convert it to a picture using the destination app’s available options.

Frequently Asked Questions

Does copying a chart also copy the worksheet data?
No. Copying the chart copies the chart object, not the cells behind it. The chart may continue to refer to its original data range. Copy the data separately if you need a self-contained chart in a different workbook.

Can I copy a chart to another worksheet?
Yes. Select the chart border, copy it, select the destination sheet, and paste. Check its data source afterward, especially if you want the chart to use data on the destination sheet rather than the original one.

Can I copy a chart from Excel into Word or PowerPoint?
Yes. Copy the chart in Excel and paste it in the other app. Use normal paste for an editable chart, or choose a picture option when you only need a fixed visual. The available paste choices depend on the destination app and version.

How do I make a duplicate chart show different data?
Copy and paste the chart, select the duplicate, and choose Chart Design > Select Data. Change the chart data range or edit its series so they refer to the cells for the new dataset. Verify the category labels and series names as well as the values.

Can I copy a chart without changing its formatting?
Ordinary copy and paste generally carries the chart’s formatting along with it. Check the pasted chart, as theme colors or formatting can look different in another workbook. Pasting as a picture preserves its appearance more rigidly, but removes chart editing and live data updates.

What is the difference between copying a chart and moving it?
Copying leaves the original chart in place and creates another object. Moving transfers the chart to a different location or sheet, so the original location no longer contains it. Use copy and paste when you want both versions.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.