Software

Automatically add new data to an Excel chart

Once you go through all the work of creating and formatting a chart, you don't want to have to start over again when new data comes in. Fortunately, you don't have to with Excel. You can simply copy and paste the new data to your chart. Here's how.

Once you go through all the work of creating and formatting a chart, you don't want to have to start over again when new data comes in. Fortunately, you don't have to with Excel. You can simply copy and paste the new data to your chart.

For example, you create a chart from data that includes income totals for January, February, and March in columns A, B, and C. After entering the totals for April into column D, you want to update your chart with this data. Follow these steps:

  1. Select the new data in column D, including the name of the month.
  2. Press [Ctrl]C.
  3. Click on the chart.
  4. Press [Ctrl]V.

With Excel 2003 and earlier versions, dragging and dropping the selected data to the chart will also update the chart. Excel 2007 does not support the drag-and-drop feature, but it does let you convert your spreadsheets into tables so Excel will update the chart without you having to manually copy and paste the new data. Follow these steps to convert your Excel 2007 data into a table:

  1. Select a cell in the source data.
  2. Press [Ctrl]T.

Now when you add a column of data for April to the table, Excel 2007 automatically extends both the table and the chart.

Miss an Excel tip?

Check out the Microsoft Excel archive, and catch up on our most recent Excel tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

3 comments
erins.ghost
erins.ghost

I used to spend hours constantly rearranging cells, and updating charts and pivots in Excel until I found a tool that eliminates all this mess. It also eliminates Excel's 65K/1M rows limitation. I still work with Excel, but I don't use it to analyze and visualize data anymore. This product is really cool. It's called Prism (by SiSense). If you've had enough with these Excel nightmares, you should give it try. Enjoy.

rosenee2003
rosenee2003

If we use Pivot table and chart wizard it is automatically update the chart data no need these steps regard rose

Forgen
Forgen

If you copy an entire chart (not a sub-component), then click on a second chart and click Paste it will insert all of the series into the second chart and apply formatting from the first chart to the second. Thus, if you want to add data to an existing chart another method is to select the new data and make a new chart (with any formatting). Then copy the old chart (with several months worth of series) and past it onto the new unformatted chart. Then simply replace the old chart with the new. Not quite as elegant as pasting the data range directly, but useful in other circumstances (although sometimes unpredictable!).

Editor's Picks