If the charts design after update changes, please save the chart design first before update the data:

select chart, then Right-click > save as a template > set a name and click ok

Save charts as Template | www.other-levels.com

Then after update the data, Go to change chart type menu > choose the saved designrestore saved chart template | www.other-levels.com