Chart & Visualization Issues

How to Copy or Separate an Excel Chart Legend

Huda QurayshiHuda Qurayshi Nov 3, 2026 874 views

Question details

The user wants to copy or separate a chart legend from an Excel chart to use it independently, such as in a Word document caption.

How to Copy or Separate an Excel Chart Legend
Product
Microsoft Excel
Device & OS
not provided
Scenario
Extracting or isolating a chart legend outside of the main chart area for use in external documents or custom layouts.
Observed behavior
Excel treats the legend as an integral part of the chart object, lacking a built-in command to copy or separate it directly.
Before you start

Ensure your original chart is fully finalized with the correct colors, labels, and data series before attempting to isolate the legend, so you do not have to repeat the workaround process.

Solution 1Recommended

Duplicate and Crop the Chart

Create a copy of the entire chart and remove all visual data elements to leave only the legend visible as a standalone object.

Since Excel does not allow you to select and copy just the legend, the most reliable method is to duplicate the entire chart object and hide everything except the legend.

1
Duplicate the chart

Click on the edge of your original Excel chart to select it. Press Ctrl+C to copy, then click an empty cell and press Ctrl+V to paste a duplicate.

2
Remove chart elements

Select the newly duplicated chart. Click the green plus icon (Chart Elements) next to the chart and uncheck all elements except for 'Legend'.

3
Hide the plot area

Click on the plot area (the actual grid/graph inside the chart area). Right-click and choose 'Format Plot Area', then set both Fill and Border to 'No Fill' and 'No Line'.

4
Resize and position

Shrink the outer boundaries of the duplicated chart so that it snugly fits around the legend. You can now copy this minimized chart object and paste it into Word as if it were a standalone legend.

Paste as Picture in Word: When pasting the isolated legend into Word, use the 'Paste as Picture' option to prevent the document theme from altering your legend's colors.
Free Microsoft Office alternative

A Free, Highly Compatible Alternative to Microsoft Excel

Separating a chart legend in Excel requires manual workarounds due to built-in software limitations. If you are looking for a versatile, lightweight suite for your data visualization needs, WPS Office offers a powerful and completely free alternative.

  1. 1. Download WPS Office: Visit the official WPS website and download the free installation package for your operating system.
  2. 2. Open your spreadsheet: Launch WPS Spreadsheet and easily open your existing .xlsx files without losing any chart formatting.
  3. 3. Customize your charts: Use the familiar ribbon interface to edit, duplicate, and format your charts seamlessly.
Fully compatible with Microsoft Excel (.xlsx, .xls) and Word formats.Advanced charting tools with an intuitive, familiar interface.Lightweight installation that runs smoothly on Windows, Mac, and Linux.Free to use, reducing software costs without sacrificing functionality.
microsoft office alternative - wps office

Frequently Asked Questions

Can I save just the Excel chart legend as a picture?

You cannot directly right-click and save only the legend in Excel. However, you can use the Snipping Tool (Windows) or Cmd+Shift+4 (Mac) to take a screenshot of the legend and save it as an image file.

Why does the legend format change when I paste it into Word?

If you paste a duplicated chart object normally, Word may attempt to link the data or adapt the colors to the active document theme. To prevent this, copy the legend, right-click in Word, and select 'Picture' under Paste Options.

How do I move the legend outside the chart area in Excel?

By default, Excel constrains the legend within the chart area boundaries. To place a legend anywhere else on the spreadsheet, you must use the workaround of duplicating the chart and hiding all other elements, or by drawing it manually.