To prevent this from happening, you can use Excel's built-in security measures to lock the chart's position on the spreadsheet. Open the Microsoft Excel 2010 spreadsheet that contains your chart.

To lock the position of a Chart and prevent it from moving in an Excel spreadsheet, follow these steps- Right-click on the existing chart. Select the Format Chart Area option from the context menu.

Whether you've earned a data-related job promotion or recently learned some new Microsoft Excel skills, take the How-To Geek Intermediate Excel Test to put your expertise under the microscope! This is ...

The collection includes nearly 100 lectures and more than eight hours of training to help a complete spreadsheet novice get comfortable and innovate in the Excel environment.