How to edit on excel6/19/2023 ![]() ![]() You can fix this problem in the same way. In this case, you may see space left in the chart for values that no longer exist. The opposite problem can occur if you delete information in cells that contain source data for the chart. To fix this problem, just select the chart, and drag one of the data handles down to include the cells that contain new values. That's because the chart's reference to the source data is static and doesn't expand automatically. However, if we add data at the bottom of the range, the chart is not updated to include this new information. If we edit any values in this range, the chart is automatically updated. Just click Calculation Options and confirm that Automatic is checked.įor this chart, the source values are in the range B7:C11. ![]() You can verify that Calculation is set to automatic on the Formulas toolbar. That's because Excel will automatically update the chart when the source data changes, as long as the calculation is set to Automatic. In this lesson we'll look at how to keep your chart updated with the latest values, and how to add more data to your chart when needed.Īfter you've created a chart, you normally don't need to worry about updating the chart manually.
0 Comments
Leave a Reply. |