The resulting chart needs to automatically update to reflect the new average. Fortunately, Excel automates most of these tasks as long as you set up your spreadsheet correctly. How to Add Data in ...