peltiertech.com
Properties Follow Chart Data Point - Peltier Tech Blog
Custom charts lose their formatting when the data changes, due to an Excel setting called "Properties Follow Chart Data Point", described in this tutorial.