What are Excel Charts?

First, select all the cells and go to the Recommended chart option in the Insert tab.

Then apply any of these Recommended Charts

→The "Recommended Charts" feature in Excel suggests the most appropriate charts based on the selected data.

We can also apply a new theme and change the chart heading name

Now if we want to add a new row, and we want automatic upgradation, we have to convert the data to a table

Converting data into tables allows the automatic addition of new data to charts.

Let's see if new rows are getting upgraded automatically or not