How to Add Data to an Existing Chart in Excel (3 Ways, One of Them Permanent)

Quick answer

Type the new numbers directly below or beside the data the chart already uses, click the chart, and drag the coloured sizing handle on the worksheet to cover the new cells. The chart redraws immediately. If the chart lives on another sheet, right-click it, choose Select Data and re-select the whole range including the new rows. To never do this again, turn the source range into a Table (Ctrl+T) before you build the chart — a chart based on a Table grows with it automatically.

An Excel chart is a picture of a range, and the range is fixed at the moment you insert the chart. Add a month, a region or a product afterwards and the chart keeps looking at the old rectangle. There are three ways to point it at the new data: two are quick fixes, the third is the one that stops the problem recurring.

Way 1 — drag the sizing handle (chart on the same sheet)

This is Microsoft’s first method, and it is the one to reach for when the chart sits next to its data¹:

1. “On the worksheet that contains your chart data, in the cells directly next to or below your existing source data for the chart, enter the new data series you want to add.”
2. “Select the chart. The currently displayed source data is selected on the worksheet, showing sizing handles.”
3. “On the worksheet, drag the sizing handles to include the new data.”

Two things to know. The new data must be adjacent — directly under the last row or directly to the right of the last column — because the handle can only stretch a rectangle. And the colour of the outline tells you what it is: in a typical column chart the category labels, the series names and the values each get their own coloured box, so if you extended the values but the new column has no label, drag the label box too.

Way 2 — Select Data (chart on a different sheet, or non-adjacent data)

When the chart is on its own sheet there is nothing to drag. Microsoft’s route¹: enter the new data next to the existing source, go to the sheet with the chart, then “Right-click the chart, and then choose Select Data.” With the dialog open, “select in the worksheet, and then click and drag to select all the data you want to use for the chart, including the new data series,” then OK.

Select Data is also the place to add a series that is not adjacent: click Add under Legend Entries (Series), point the name box at the header cell and the values box at the numbers. And if the new series is a different kind of quantity — a percentage next to revenue — this is where you will later change its chart type or move it to a secondary axis.

Way 3 — build the chart on a Table so it grows by itself

Editorial technique

Select the source range, press Ctrl+T, confirm the header row, and insert the chart from the Table. A Table is a named object whose boundary expands when you type in the row directly beneath it, and a chart that references a Table references the whole Table — so a new row becomes a new point or bar the moment you press Enter, with no dragging and no dialog. Anything that reads the Table, from a SUM in the total row to a PivotTable, expands the same way. This is our recommendation rather than a quoted Microsoft step; the mechanism is the Table’s structured reference, not a chart setting.

Two habits make this bulletproof. Keep the Table free of blank rows, because a blank row is where the Table thinks it ends. And type new data in the first empty row directly under the Table rather than a few rows down, which would create loose cells outside it. If you paste a block that is larger than the Table, Excel extends the Table to fit.

Changing existing values

Editing a number the chart already plots needs nothing: “Changes you make will instantly show up in the chart.”² Microsoft’s page on updating chart data also describes the handle drag from the other direction — select the chart, then drag the lower-right corner of the highlighted range to add or remove data². Shrinking the range is how you drop a month without deleting it from the sheet.

When the chart still does not update

The new data was typed with a gap. A blank row between the old data and the new means the handle has to cross a gap and a Table has already ended. Delete the blank row.

The series is there but invisible. Check the axis: a series in thousands added to a chart in millions is a flat line along the bottom. Right-click the series → Format Data Series → Secondary Axis.

The category labels did not follow. You dragged the values box but not the labels box. Re-select the chart and drag the other coloured outline, or use Select Data → Horizontal (Category) Axis Labels → Edit.

The chart is a PivotChart. PivotCharts do not use a range at all; they read a PivotTable. Refresh the PivotTable (right-click → Refresh) and, if the source was not a Table, widen its source under PivotTable Analyze → Change Data Source.

On the exam

“Manage charts” is its own objective group on exam MO-210, weighted 15–20%³, and modifying a chart’s data range is one of the tasks in it. The Expert exam, MO-211, spends 25–30% on “Manage advanced charts and tables”⁴, where Tables as chart sources and secondary axes are routine. Both are hands-on: you will be given a workbook and told to add the series, not asked which menu it lives under.

Related

• Delete a chart in Excel — or all of them at once
• SUMPRODUCT: sum values based on several conditions
• Copy only visible cells — when the chart data comes from a filtered list
• MO-211 Excel Expert exam guide

Sources