- 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.
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.