After you create a chart, you don’t have to worry about updating the chart when values change.
Just click Calculation Options and confirm that Automatic is checked.
In this chart, the source values are currently in the range C5:C9.
If I edit any value in this range, the chart automatically updates.
That’s because the reference to the source data is static, and doesn’t automatically expand.
The chart will immediately update.
The opposite problem can occur when source data is removed.
In this case, you may see space left in the chart for values that no longer exist.
you’ve got the option to fix this problem in the same way.
it’s possible for you to use the same approach to add and remove data series.
For example, here I can drag to add the values in the Expense column to the chart.
To exclude Expenses again, I just reverse the process.
We’ll take a look at Chart Filters in more detail, in a separate video.
