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.

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.