Question

1.) The chart will reflect changes if the
data in excel sheet
changes

Answer 1

Answer:

Charts are updated automatically in Excel whenever data changes. ... Any data changed in the worksheet is automatically updated in the chart.

Answer 2

Answer:

If you need to change data in a chart, you can do it from its source. ... to a chart, make updates in your table and you'll see the changes reflected in the chart.

Explanation: