Excel automatically redraws the chart _______

The correct answer is Option (4) → If any change is made in both data and range data

A chart in Excel stays linked to the worksheet range it was made from. Whenever a value in that data is changed, or the data range of the chart is changed, Excel redraws the chart at once to show the new figures; nothing has to be redrawn by hand.

Option (1) If any change is not made in data. — Incorrect. If nothing changes, there is nothing to redraw.

Option (2) If any change is made in data only. — Incorrect. A change in the data range also redraws the chart, so “only” makes this wrong.

Option (3) If any change is made in range data only — Incorrect. A change in the data values also redraws the chart.

Option (4) If any change is made in both data and range data — Correct. Both kinds of change are reflected in the chart automatically.