Typically, data changes update automatically on a chart, but which changes do not automatically update?

• A. Additions
• B. Updates
• C. Deletions
• D. Edits

Answer: (A)

Charts pull their values from a defined data range. When you edit a value or otherwise change data that already exists within that range, the chart updates automatically because the points it displays are directly tied to those cells. Adding new data, however, typically sits outside the current chart range. Unless the range is set to expand automatically (for example, if the data is in a dynamic table that grows as you add rows), those new additions won’t appear in the chart right away. That’s why additions don’t update automatically, while changes to data already in the chart’s range—updates, deletions, or edits—do.