If you go to file and options and then select advanced. scroll down until you find chart options. Untick the last box that says Properties follow chart data point for the current workbook
then copy and paste the chart again and the formatting should remain in place
