Fix Cannot Copy Box and Whisker Chart from Excel Chart Sheet
Question details
The user is unable to copy a Box and Whisker chart once it has been moved to a dedicated chart sheet in Excel.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to copy a formatted Box and Whisker chart from an Excel chart sheet to paste it into another application like PowerPoint or Word.
- Observed behavior
- Excel blocks or ignores the copy command when the Box and Whisker chart is located on a dedicated chart sheet, though it copies normally from a standard worksheet.
Ensure your Excel application is updated to the latest version, as Microsoft frequently patches charting bugs. Additionally, have your destination application (like PowerPoint or Word) open and ready.
Copy the Chart Directly from the Original Worksheet
Since the bug occurs specifically on dedicated chart sheets, moving the chart back to a standard worksheet allows for normal copying and pasting.
This is the most reliable workaround for this specific Excel behavior. The copying limitation seems isolated to the chart sheet environment for Box and Whisker diagrams. By keeping the chart embedded in a regular worksheet, clipboard functions will work as expected.
If your chart is already on a chart sheet, right-click the chart area and select 'Move Chart'. Choose 'Object in' and select your original data worksheet.
Click on the Box and Whisker chart within the standard worksheet to highlight it.
Press Ctrl+C on your keyboard, or right-click the chart border and select 'Copy'.
Open your PowerPoint presentation or Word document, click where you want the chart to appear, and press Ctrl+V.

Report the Issue to Microsoft Support
Because this is a known behavior across multiple Excel versions, reporting it helps prioritize a permanent fix from the development team.
Try WPS Office for Seamless Data Visualization
If persistent Excel bugs are slowing down your workflow, consider switching to WPS Office. It provides a lightweight, free, and highly compatible spreadsheet tool that handles your complex charting needs without the frustrating glitches.
- 1. Download the software: Visit the official WPS Office website and download the free installation package for your operating system.
- 2. Open your spreadsheet: Launch WPS Spreadsheets and open your existing .xlsx file containing the raw data.
- 3. Create and manage charts: Insert your desired charts easily and copy them flawlessly across your documents and presentations.

Frequently Asked Questions
Why can't I copy a Box and Whisker chart from a dedicated chart sheet?
This is a known software limitation or bug in certain versions of Microsoft Excel affecting specific statistical charts. Excel struggles to process the clipboard copy command when a Box and Whisker chart is isolated on its own chart sheet rather than being embedded in a standard worksheet.
Can I save the chart sheet as an image instead of copying it directly?
Yes. As an alternative workaround, you can use a screen capture tool (such as the Snipping Tool on Windows or Shift+Command+4 on Mac) to grab a high-quality image of the chart sheet, which you can then paste directly into PowerPoint or Word.
Will updating my Office suite fix this chart copy issue?
Microsoft frequently releases patches for Office applications to address known bugs. While this specific issue has persisted across several versions, keeping your Office suite updated ensures you will receive the official fix as soon as it is rolled out.
How do I move a chart sheet back to a normal Excel worksheet?
Right-click the background area of the chart on the chart sheet, select 'Move Chart' from the context menu, choose the 'Object in' option, and select the specific worksheet where you want the chart to reside from the dropdown menu.




