Chart design changed, How can maintain the chart design?

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

1. Click to select your chart

2. Right-click the chart area

3. Choose Save as Template

4. 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

1. After refreshing or changing your data

2. Select the updated chart

3. Go to Chart Tools > Change Chart Type

4. Select Templates tab

5. Choose your saved chart design to reapply the look instantly