Excel: Add New Data to a Chart

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.


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.

  1. Copy the new data.
    1. Click on the chart.
    2. Ctrl+V to paste. The new data is added to the existing chart.

  2. 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.

  3. 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: 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.

  4. 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.

  5. Drop the blue box on Exxon and the chart redraws.

For more resources for Microsoft Excel