To copy and paste a graph (called a chart in Excel), select its outer border, press Ctrl+C, click where you want the copy, and press Ctrl+V. You can paste it on the same worksheet, another worksheet, or into another workbook. Before you start, open the workbook and decide whether the pasted chart should remain editable and connected to its data or be a static picture.
What You’ll Need
- Excel for Microsoft 365 on Windows, or Excel for Mac or the web if that is where your workbook is open.
- A workbook containing the chart you want to copy and, if you are moving the chart, the destination sheet or workbook.
- Permission to edit the destination workbook. If it is protected or read-only, you may need to enable editing or save an editable copy first.
You do not need to select or copy the chart’s source cells just to duplicate the chart. Copying the chart object normally preserves its chart type, formatting, labels, and series. The chart’s relationship to its source data can depend on where you paste it, so check that relationship after copying between workbooks.
Step-by-Step
- Open the source workbook. Go to the worksheet that contains the chart. If you have not created the graph yet, select the data range and use Insert to create a chart first. Save the workbook before making substantial changes, especially if you are copying between files.
- Select the chart object, not a chart element. Click a blank area near the chart’s edge or its outer border. You should see handles around the entire chart. If only a title, legend, data point, or plot area is selected, click the outside border again. Selecting the whole object matters: copying a selected title, for example, will copy or edit only that element rather than duplicate the complete chart.
- Copy the chart. On Windows, press Ctrl+C. You can also use Home > Copy. On a Mac, press Command+C or use Home > Copy. A moving dashed outline may appear around the chart; that indicates the chart is on the clipboard. Avoid clicking inside the chart and dragging, because that can move or resize it rather than copy it.
- Choose the destination. To put the copy on the same sheet, click an empty area where the chart will fit. To use another sheet in the same workbook, click its worksheet tab. To paste into a different workbook, switch to that workbook; if it is not open, open it and then return to the copied chart only if the clipboard still contains it. Leave enough room for the chart so it will not cover important cells or another object.
- Paste the chart. Press Ctrl+V on Windows or Command+V on a Mac. You can also use Home > Paste. Excel places a second chart at the destination. If it overlaps the original or other content, select its border and drag it to a clear location. To reposition it precisely, use the arrow keys after selecting the chart; hold Ctrl while pressing an arrow key on Windows to move it in smaller increments where supported.
- Check the chart and its data. Confirm that the pasted chart displays the expected title, series, labels, and values. When the chart is in the same workbook, it will usually continue to refer to the original source cells, so edits to those cells can update both copies. After pasting into a different workbook, do not assume the data is now independent: the chart may still refer to the original workbook. Select the chart and use Chart Design > Select Data to inspect the chart data range or series references.
- Choose a paste option if you need a different result. After pasting, look for the Paste Options button beside the chart. Depending on the destination and Excel version, you may be able to keep source formatting, use destination formatting, or paste a picture. The available choices vary, so read the option labels before selecting one. If you want a dependable static image, use the picture method in the next step rather than expecting a regular chart paste to become an image.
- Copy the chart as a picture when it should not be editable. Select the chart’s outer border. In Windows Excel, open Home > Copy ▼ > Copy as Picture, choose the appearance options, and select OK. Then click the destination and press Ctrl+V. In Excel for Mac, use the available Copy as Picture command if it appears in the Home ribbon or chart context menu; its location and options can differ by version. A picture will not update when the source data changes and cannot be edited as a chart.
- Save and verify the destination. Save the workbook after checking the placement and data. If you copied into another workbook, reopen it or check its links before sharing. If the chart is meant to update from data in the destination workbook, use Select Data to confirm its series point to the intended cells rather than relying on the chart’s appearance alone.
Excel for the web: The basic process is similar: select the chart, use Ctrl+C and Ctrl+V on Windows, or Command+C and Command+V on a Mac, and select the destination worksheet before pasting. Browser clipboard permissions and the web version’s available paste choices can affect copying between workbooks or apps. If a chart will not copy in the browser, try opening the workbook in the desktop app. The desktop version also provides more chart editing and picture-copy options.
Common Mistakes
- Copying a chart part instead of the whole chart. Clicking the title, legend, or a data point may select only that component. Check for handles around the chart’s outside edge before copying.
- Assuming the copy has its own data. A duplicated chart can remain tied to the original cells. A copy in a different workbook may also retain references to the source workbook. Inspect the data range if the chart must be self-contained or update from different cells.
- Using a picture when future updates are needed. A pasted image is only a snapshot. It will not respond to changed values, filters, or source data. Keep an editable chart if it needs to stay current.
- Dragging instead of copying. Dragging the chart border moves the original. Use the keyboard copy-and-paste commands to create a second object.
- Overlooking hidden or filtered data behavior. A pasted chart may preserve settings that exclude hidden rows or columns, or its displayed values may depend on filters. Check the chart’s data and settings if the copy looks incomplete.
- Pasting into a protected sheet. A protected worksheet may prevent adding or moving chart objects. Check the Review tab for sheet protection, and ask the workbook owner for access if you cannot change it.
Tips
- Keep the chart editable when you expect revisions. Regular chart copying preserves the chart object, so you can change its design, title, labels, and series later. If the copy should show different data, change its source through Chart Design > Select Data rather than editing the original chart by accident.
- Use a picture for reports that need a fixed appearance. A picture can be useful in a presentation, email, or document where the recipient should see the chart but should not change it. Remember that a picture may become blurry if enlarged, and it will not reflect later changes in Excel.
- Make room before pasting. Click an open area of the destination sheet, then move the chart by its border. To avoid an accidental resize, drag from the middle of an edge rather than from a corner handle.
- Keep formatting consistent. If you paste a chart into a sheet with a different theme, review its colors, fonts, and background. Paste options may offer destination formatting, but selecting that can change the chart’s appearance.
- Consider the source workbook’s availability. If a copied chart refers to cells in another workbook, changes or missing access to that source can affect the chart’s data. Keep the source file accessible, or deliberately redirect the chart to data stored in the destination workbook.
- Use a worksheet tab copy for a whole report sheet. If the chart sits with supporting tables, notes, and formatting that you also need, copying the entire worksheet may be more suitable than copying only the chart. Right-click the sheet tab and choose Move or Copy; select Create a copy and choose a destination. This duplicates the sheet, not just the graph.
Troubleshooting
Nothing happens when you paste: Click the destination worksheet or workbook first, then try Ctrl+V (Command+V on Mac). Confirm that the chart still has a selection outline and that the destination is editable. In Excel for the web, allow clipboard access if your browser asks, or use the desktop app if browser restrictions prevent the paste.
The pasted chart shows the wrong values: Select the pasted chart and choose Chart Design > Select Data. Review the chart data range and each series. If the series point to the old workbook or the wrong worksheet, update the references to the intended cells. If the source workbook is closed, external references may include its file name and path; make sure that file is available before relying on the chart.
The chart pasted as a picture or cannot be edited: You may have chosen a picture paste option or used Copy as Picture. Undo immediately with Ctrl+Z on Windows or Command+Z on Mac if appropriate, then copy the original chart again and use a regular paste. A picture cannot be converted back into a fully editable chart; return to the original chart or create a new chart from the source data.
The copy is missing labels, colors, or other formatting: Check the Paste Options button and try a different available option. Also check whether the source chart uses a theme, custom fonts, or formatting that is unavailable in the destination. You can select the pasted chart and adjust its design using Chart Design and Format.
The chart is behind cells or another object: Select the chart border and move it to an open part of the sheet. If another shape or chart covers it, use the selection pane from the Home tab’s Find & Select menu to locate objects and adjust their order. If the worksheet is protected, the owner may need to unprotect it before objects can be moved.
The pasted chart does not update after data changes: First determine whether you pasted an image; images never update. For an editable chart, inspect Chart Design > Select Data and confirm that the referenced cells contain the changed values. If the chart depends on an external workbook, check that links are available and that the series still point to the correct source.
Frequently Asked Questions
How do I copy a graph to another sheet in the same workbook?
Select the chart’s outer border, press Ctrl+C, click the destination sheet tab, and press Ctrl+V. On a Mac, use Command+C and Command+V. Check whether the pasted chart should keep using the original data.
Can I copy a chart from one Excel workbook to another?
Yes. Copy the chart, switch to the destination workbook, and paste. Then use Chart Design > Select Data to check the source references. If the chart should use destination data, point its series to the appropriate cells.
Will copying a chart copy the data too?
Not necessarily. Copying a chart copies the chart object, but its data may remain in the original worksheet or workbook. Copy the source data separately if you need it in the destination, then check or change the chart’s data range.
How do I paste a chart as an image?
In Windows Excel, select the chart and choose Home > Copy ▼ > Copy as Picture. Choose the desired appearance, select OK, and paste where needed. Mac and web options vary by version; if the command is unavailable, use the desktop version or take another suitable image capture.
Can I copy a chart without changing the original?
Yes. Copy and paste creates a second chart object; it does not remove the original. However, both charts can refer to the same data, so changing the source cells may update both.
Why does my chart look different after I paste it?
The destination theme, paste option, or available fonts may change its appearance. Try another Paste Option, then review the chart’s colors, fonts, and labels. If the appearance must remain fixed, paste it as a picture instead.
Related
- How to Convert an Excel Spreadsheet to Word
- How to Convert an Excel Document to Word
- Convert an Excel File to a Google Doc: Step by Step
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Speedometer Chart in Excel: A Practical Step-by-Step GuideTo create a speedometer chart in Excel for Microsoft 365 on Windows, make a doughnut chart from three…
- Excel Gantt Chart Scroll Bar: Setup and TroubleshootingYes. In Excel for Microsoft 365 on Windows, add a Form Control scroll bar and link it to…
- Does Excel Online Have Sparklines? Setup and LimitsYes. Excel for the web—often called Excel Online—can create and format sparklines, the small charts that fit inside…
- How to Create a Stacked Column Chart in ExcelTo create a stacked column chart in Excel, arrange categories in the first column and each data series…
- Excel Column Chart With Two Y-Axes: Setup and TipsTo make an Excel column chart use two y-axes, select the chart and choose Chart Design > Change…
- Excel Graph: Hide Zero Values Without Hiding DataTo hide zero values in an Excel graph while keeping the underlying data, create a helper column that…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.