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.
Kirk Bennet started writing for websites and online publications in 2005. He covers topics in nutrition, health, gardening, home improvement and information technology.