Line chart with line per year

[advseb]

I have a table where I note down temperature on a given date. So something like that:

01/12/2018 | 10
03/12/2018 | 9
...
30/11/2019 | 11
03/12/2019 | 6

Now I want to produce a chart where I can see a line for all values of a year. I don’t know the technical name for such a chart, at least I can’t find any useful tutorials how to produce it. Here a link to a chart I’m looking for:

So the point is that I only have 2 columns, one with date and second with some measure and I want to visualize in the chart if there are any significant changes or if the values are similar.

[Edit - Opaque] Formatted data structure for better readability

[mgl]

Hello @advseb

Here is the way I would do it :

Add a column to extract the year : this will help to see the different ranges of data for every year and to give a name to each line.

Compute the position of the date in its year. If A2 contains the date, this position will be given by =A2-DATE(YEAR(A2);1;1)+1. Apply a format like DD/MMM to this position. It will look like a day.

Then create a X-Y diagram with one data range per year.

Eventually, you do not need the column D and F.

277071-line-chart-with-line-per-year.ods

---

To show the community that the question has found its answer, please click on the ✓ aside the top of the correct answer.

Please do not use Add Answer but edit your original question to enhance the details of your question (answers are reserved for solutions to a problem on this Q&A site). Thanks in advance …

Kind regards, Michel

[advseb]

Thank you, that works. I expected that this is somehow possible automatically.