How to Lock Charts in Excel

Excel can create a number of charts, including pie charts.

Excel 2010 is a powerful spreadsheet program that can help you create professional-looking charts and tables from your data. If you've created a complex chart, you may not want the casual user to be able to make changes to it. The solution is to protect the worksheet with a password, which protects all of the worksheet elements, including charts and graphs.

Instructions

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.

References

• Microsoft Office: Password Protect Worksheet or Workbook Elements