If you insert or resize columns and rows in a spreadsheet, the position and size of your charts change. Charts automatically relocate because they are set to move and resize with cells. Fortunately, you can lock the position of a chart in Microsoft Excel.
