How to Lock the Position of a Chart in Excel

By Kirk Bennet

You can insert many types of data in your Microsoft Office Excel spreadsheets, including charts, plain text, images and tables. If you insert a chart in a spreadsheet and you then insert additional data, the position of the chart changes. This is because the chart is set to move and size with the cells in your document. To lock the position of the chart, you need to edit its properties.

Launch Microsoft Excel 2010 and open or create a spreadsheet.

Locate the chart that you want to lock, right-click on an empty space and choose "Format Chart Area" from the context menu. The Format Chart Area window opens.

Click "Properties" in the left pane to view the properties of the chart in the right pane.

Click the "Don't move or size with cells" radio button to lock the position of the chart, and then click "Close" to close the Format Chart Area window.

Press "Ctrl-S" to save the latest version of the spreadsheet.