Thanks to Juice for their Excel chart cleaning tool. I will be trialling it for a while, but boy is it necessary.