Level 1 (78 points)

Numbers chart adds new year's data to previous year's series

Hello, I’m trying to add 2027 data to a chart but Numbers adds them to the 2026 line:

To the left is the table, to the right is the chart … it shows the use of heating oil over several years.

The content of the sheet (table and chart titles) is in German, but my user account and application languages are in English, which is why I am asking here and not in the German part of the Community Forum.

My problem: when I click “Edit Date Reverences”, I get this:

So far, so good.

But when now I click in the the first cell, for January 2027, and drag down, this happens:

I.e., instead of adding a new series (term?) for 2027, the data gets added to the series for 2026. What am I doing wrong?

As you can see, I have successfully done this in the past years, but I am old and have forgotten how I did it 🤦‍♂️

I’d be happy if someone could help me 🙂

TIA,

Tom in Germany

Posted on Nov 2, 2026 11:21 AM

3 replies

Camelot

Level 9 (62,211 points)

Nov 2, 2026 11:58 AM in response to Tom in Germany

From the look of it, you need to add a new series, rather than extending the existing ones.

Looking at the graph, you have one series of data plotting the values for 2024.

Another series for 2025.

Then a third series covering 2026 and 2027. That's why this line extends the graph rather than adding a new plot line.

What isn't clear is how you created the chart in the first place, since you seem to have multiple series from the same column (Numbers usually groups series by columns, and it's not usual to have multiple series from one column. That may have something to do with the categories you're using.

Tom in Germany Author

Level 1 (78 points)

Nov 2, 2026 12:25 PM in response to Camelot

Yes, I have multiple series of data, plotting the values for every year beginning with 2013, and the cells for these years are all in the same column, so … it is possible, and apparently not a bug in Numbers but a legitimate way to do it, I’d think. But I cannot, for the life of me, remember how I did it.

There are a lot more columns actually in the table, In order to focus on the necessary stuff I hid them and removed the conditional colouring of the cells. The full table looks like this, with estimated values for 2027:

Tom in Germany Author

Level 1 (78 points)

Nov 4, 2026 5:51 AM in response to Tom in Germany

Nobody else? 😳

Originally posted at discussions.apple.com/thread/256387721