Thanks to Excel’s string functions ... MID() returns a substring from the middle of a source string and FIND() returns the position of a specific string within a source string.

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.

Although the chart moves as per the cells’ width and position, you can disable this. In Excel, it is straightforward ... Otherwise, you cannot find the option that is mentioned below.