Permission & Access Issues

Fix an Excel Chart That Cannot Be Moved on a Worksheet

Muhammad TalhaMuhammad Talha Nov 18, 2026 868 views

Question details

The user needs to move an Excel chart on a worksheet.

Why an Excel Chart Cannot Be Moved 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.
Before you start

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.

Solution 1Recommended

Unprotect the Worksheet and Move the Chart

Use this method if worksheet protection is preventing changes to the chart.

1
Check sheet protection

Right-click the worksheet tab containing the chart. If the menu shows Unprotect Sheet, the sheet is protected.

2
Unprotect the sheet

Click Unprotect Sheet and enter the password if prompted. If you do not know it, ask the workbook owner.

3
Move the chart

Click the chart to display its selection handles, then drag its outer border to the desired location.

Unprotect the Worksheet and Move the Chart
Allow object editing when protecting the sheet: If you need to protect the sheet again, use Review > Protect Sheet and check whether the Edit objects permission is available. Allowing it lets users edit objects while the sheet is protected.
Free Microsoft Office alternative

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.

Select and reposition charts in spreadsheet worksheetsCompatible with Microsoft Excel XLS and XLSX formatsFamiliar spreadsheet interface for easier migrationFree and lightweight office suite
microsoft office alternative - wps office

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.