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.

How to Change a Range in Microsoft Excel. When you copy a formula, referenced ranges automatically adjust according to the formula's new position unless the ranges use absolute references.

Change the size of the slicer to accommodate the new columns. With the slicer selected, position it (drag it) over the top of the chart. Don’t worry about removing the text above the title; drag ...