How to Lock Charts in Excel

1. Open the worksheet with the graph in Excel.
2. Click the 'Review' tab and then click 'Protect Sheet.'
3. Click 'Allow All Users of This Worksheet To' and then select the elements you want people to be able to change. For example, even though the chart is protected, you may want users to be able to format cells, insert rows or perform sort functions on the worksheet.
4. Type a password into the 'Password to Unprotect Sheet' box and then click 'OK.' You need to type the password again to confirm it.