Share via

Excel 2024 - How to add a new month to the existing bar chart?

davidhelp 20 Reputation points
2026-05-28T16:41:09.03+00:00

Question: How to add a new month to the existing bar chart in Excel 2024

I have 3 rows. Oct 2025, April 2026, May 2026

The headings are: Month, Start Value, End Value, Change

The bar chart has the 3 start values and then the 3 end values then the 3 change

I added a 4th row and the formulas and they change values as they should.
The June values are just dummy values.

But I do not know how to add the 4th month to the existing bar chart that updates as well.

I can create a new one but then I have to re-create the chart details.

Microsoft 365 and Office | Excel | For home | Windows
0 comments

Answer accepted by question author

John Jefferson Doyon 71,160 Reputation points Independent Advisor
2026-05-28T18:08:01.82+00:00

Hi, I'm John! I will help you with this.

You should not need to recreate the chart.

If you haven't already, please try this first:

  • Click the chart.
  • Right-click it and select "Select Data."
  • Check the "Chart data range."
  • Expand the range to include the new June row.

Example:

  • If the current range is: A1
  • Change it to: A1
  • The chart should then include June automatically.

If you want future months to add automatically without editing the range each time, you can also convert the data into a Table first:

  • Select the data
  • Press Ctrl + T
  • Then create/use the chart from that table

Excel charts linked to Tables usually expand automatically when new rows are added.

To help narrow down the issue:

Is your chart a clustered bar/column chart?

Did you create the chart from a normal range or from an Excel Table?

Was this answer helpful?

1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest

  1. AI answer

    2026-05-28T16:41:20.6033333+00:00

    To add the 4th month (June) to the existing bar chart so it updates with the data, extend the chart’s source data range instead of creating a new chart.

    Use either method below.

    1. Extend the chart’s data range directly
    2. On the worksheet, click once on the existing chart.
    3. Excel will highlight the data range used for the chart with colored borders around your table (Month, Start Value, End Value, Change, and the 3 existing rows).
    4. Rest the pointer on the lower‑right corner of the highlighted range until the cursor changes to a resize handle.
    5. Drag the border down to include the new 4th row (June) in all relevant columns.
    6. Release the mouse. The chart will automatically add the 4th month’s bars.
    7. Use Select Data
    8. Right‑click the chart and choose Select Data.
    9. In the Chart data range box at the top, adjust the range reference so it includes the new 4th row (for example, change $A$1:$D$4 to $A$1:$D$5, depending on where the data is).
    10. Confirm that all series (Start Value, End Value, Change) now reference the full range including the 4th row.
    11. Click OK. The chart will update to show the new month.

    If the chart is based on a structured table (Insert > Table), adding a new row to the table automatically extends the chart range; if not, use one of the methods above each time a new month is added.

    For charts that must grow automatically as data is added, dynamic ranges using defined names (for example, with OFFSET and COUNTA) can be used and then assigned to the chart’s series via Select Data.

    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.