Here's a quick and easy trick for updating an existing Excel chart.
- Select the new data that you want to add to the chart. Don't select the entire worksheet — select only the new data. As you can see below, the existing chart's data consist of the first three quarters. To add the fourth quarter to the column chart, select just the fourth quarter data.
- Press [Ctrl]+C to copy the new data to the Clipboard.
- Select the chart.
- Press [Ctrl]+V to copy the new data from the Clipboard to the new chart. A simple copy and paste task updates the existing chart by adding the fourth quarter series.