Let’s take a look.
After you’ve created a chart, you normally don’t need to worry about updating the chart manually.
you’re free to verify that Calculation is set to automatic on the Formulas toolbar.
Just click Calculation Options and confirm that Automatic is checked.
For this chart, the source values are in the range B7:C11.
If we edit any values in this range, the chart is automatically updated.
That’s because the chart’s reference to the source data is static and doesn’t expand automatically.
The chart will then immediately update.
The opposite problem can occur if you delete information in cells that contain source data for the chart.
In this case, you may see space left in the chart for values that no longer exist.
it’s possible for you to fix this problem in the same way.
you might use this same approach to add a new data series.
For example, let’s add the values in the expense column to our chart.
Just opt for chart and drag to expand the data range to include the new column.
Note that not allchart typesin Excel can be used to plot multiple data series.
