Changing series formula in Excel 2010

Changing the data in an Excel sheet is easy: Home -> Find and select.

 Replacing strings in a series formula (such as in a chart) is not straightforward.

Unless you write a VBA macro:

http://peltiertech.com/WordPress/change-series-formula-improved-routines/

http://www.excel-vba-easy.com/vba-how-to-create-macro-excel.html