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

Then after update the data, Go to change chart type menu > choose the saved design
Method Description: Preserving Chart Design When Updating Data in Excel
If your chart design resets or changes after updating data, follow these steps to save and reapply your custom chart formatting:
Step 1: Save the Chart Design as a Template
-
Click to select your chart
-
Right-click the chart area
-
Choose Save as Template
-
Set a meaningful name and click OK
-
This saves your custom layout, colors, and formatting for future use.
Step 2: Reapply the Saved Chart Template After Data Update
-
After refreshing or changing your data
-
Select the updated chart
-
Go to Chart Tools > Change Chart Type
-
Select Templates tab
-
Choose your saved chart design to reapply the look instantly
Share:
How to show or hide the Excel sheet tabs and scroll bars?
If the Database created in a Separate File from the Dashboard