What columns are needed to display 5 years of dates gas usage as 5 separate lines chart ?

[DBenz]

Hi,
column A date col B gas usage

22 December 2017 6.32
23 December 2017
24 December 2017
25 December 2017
26 December 2017
27 December 2017
28 December 2017 6.488
29 December 2017
30 December 2017 10.945
31 December 2017 7.02
01 January 2018 8.69
02 January 2018
03 January 2018
04 January 2018
05 January 2018 6.215

figures just an extract from 1825 rows (5 x 365)

I wish to have a line per year chart, along the bottom month and day, legend for line different colour per year.

Also ideally to display the max and min temperatures and radiator thermostat setting but I need to walk before run !

How should I construct the date and usage columns then highlight what to make each line ? To know how the others are added would be good.
I have only populated jan and Feb for the moment with genuine temps.

Attached the sheet currently.


Cheers

Dbenz

[TMS]

You would need to create a matrix with the days of the year in column A and the years across the top in cells B1 to F1.