Fix an Excel Chart That Cannot Be Moved on a Worksheet
Question details
The user needs to move an Excel chart on a worksheet.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user wants to select and drag a chart to a different position on the same worksheet.
- Observed behavior
- The chart cannot be dragged or does not show selection handles.
Open the worksheet containing the chart and check whether you can select it. If the sheet is protected, obtain the password from its owner before making changes.
Unprotect the Worksheet and Move the Chart
Use this method if worksheet protection is preventing changes to the chart.
Right-click the worksheet tab containing the chart. If the menu shows Unprotect Sheet, the sheet is protected.
Click Unprotect Sheet and enter the password if prompted. If you do not know it, ask the workbook owner.
Click the chart to display its selection handles, then drag its outer border to the desired location.

Check Chart Selection and Workbook Access
Use these checks if the worksheet is not protected or the chart still cannot be moved.
Work with Spreadsheet Charts in WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface. Its spreadsheet tools support common Excel formats, making it easier to bring existing workbooks into WPS. It does not remove Excel worksheet passwords or access restrictions.

Frequently Asked Questions
How can I tell if an Excel worksheet is protected?
Right-click the worksheet tab. If the menu shows Unprotect Sheet, the worksheet is protected. If it shows Protect Sheet instead, the worksheet is not protected.
What if I don't know the worksheet protection password?
Ask the workbook owner for the password or an editable copy. Excel may require the password when you select Unprotect Sheet.
Why can't I select my chart by clicking it?
Try clicking the chart's outer border. If another object makes selection difficult, use Home > Find & Select > Selection Pane and select the chart from the list.
Can I move a chart on a protected worksheet?
It depends on the protection settings. The sheet owner can use Review > Protect Sheet and allow Edit objects when setting protection, or unprotect the sheet before you move the chart.




