Excel automatically redraws a chart:
- AIf any change is not made in data.
- BIf any change is made in data only.
- CIf any change is made in range data only.
- DIf any change is made in both data and range data.
Solution & Step-by-step Explanation
Excel charts maintain real-time dynamic links to their underlying data sources. If there are any updates, edits, or structural extensions made to either the values inside the data cells (data) or the boundaries of the source cell groups (range data), Excel automatically refreshes and redraws the chart layout.