A poorly documented and poorly understood Excel setting called "Properties Follow Chart Data Point" causes much frustration when users customize their charts and change the charts' data. When Properties Follow Chart Data Point is true, custom formatting is lost when the chart's data changes. When false, custom formatting is preserved.