This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.
Add New Data to a Chart
Problem: I need to create 12 charts every month. It is a real pain to re-create these charts every month.
Strategy: You can easily add data to an existing chart.
The first method is to copy the data and paste it on the chart. Here’s how:
1. Type the new data for your chart adjacent to the old data. Be sure to add a heading.
2. Select the new data, including the heading.
3. Ctrl+C to copy the new data.
Figure 1003 Copy the new data.
4. Click on the chart.
5. Ctrl+V to paste. The new data is added to the existing chart.
Figure 1004 New data added.
The second method is to click the chart and find the blue outline around your data. You can drag one of the right handles to the right to add a new data point, drag the left handle to the right to remove a data point, or drag an edge to chart a different range.
Figure 1005 Drag the blue handle to add data
Additional Details: If you need to show a rolling six months, after adding July to the data, you can drag the blue handle from B5 to the right. You will remove January from the chart.
Additional Details: The
Additional Details: Dragging the blue outline can simplify the task of creating many charts as described in the previous topic. Create the first chart and copy it. When you select the first chart, one customer is outlined in blue.
Figure 1006 Drag the blue box to a new row.
Drag the edge of the blue box to a new customer. The chart will update. Note that if you drag the blue box, the green box will move with the blue box.
Figure 1007 Drop the blue box on Exxon and the chart redraws.