Year on year dates but next to each other on a chart

[lunaticpandora]

Hi all, first time poster, long time lurker!

I'm currently fighting with a dataset at work, where I need to show Jan-18 & Jan-19 data next to each other.

However, no matter how I arrange my data set, the Jan-19 goes to the other side.

Now, I get that it's following the sequential months/year but my questions is...

Is there anyway to present it so the data goes Jan-18 Jan-19 Feb-18 Feb-19 etc etc

Below is an image of what i've got so far:

https://ibb.co/L6fPgKf

Thanks in advance for any help

 

[jorismoerings]

Hi,

Excel will sort the columns on the date field used for your axis. Can be so;lved by adding a month column above or beside the date column.
and add that as a sorting criterium for data.
Will looks something like this:

	A	B	C	D
month	Date	#1	#2

<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1-1-2018[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]10[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]31-1-2019[/TD]
[TD="align: right"]215[/TD]
[TD="align: right"]13[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]28-2-2018[/TD]
[TD="align: right"]205[/TD]
[TD="align: right"]12[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]28-2-2019[/TD]
[TD="align: right"]195[/TD]
[TD="align: right"]11[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]31-3-2018[/TD]
[TD="align: right"]210[/TD]
[TD="align: right"]14[/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]31-3-2019[/TD]
[TD="align: right"]225[/TD]
[TD="align: right"]17[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]30-4-2018[/TD]
[TD="align: right"]215[/TD]
[TD="align: right"]16[/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]30-4-2019[/TD]
[TD="align: right"]205[/TD]
[TD="align: right"]15[/TD]

[TD="align: center"]10[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]31-5-2018[/TD]
[TD="align: right"]220[/TD]
[TD="align: right"]18[/TD]

[TD="align: center"]11[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]31-5-2019[/TD]
[TD="align: right"]235[/TD]
[TD="align: right"]21[/TD]

[TD="align: center"]12[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]30-6-2018[/TD]
[TD="align: right"]225[/TD]
[TD="align: right"]20[/TD]

[TD="align: center"]13[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]30-6-2019[/TD]
[TD="align: right"]215[/TD]
[TD="align: right"]19[/TD]

[TD="align: center"]14[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]31-7-2018[/TD]
[TD="align: right"]230[/TD]
[TD="align: right"]22[/TD]

[TD="align: center"]15[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]31-7-2019[/TD]
[TD="align: right"]245[/TD]
[TD="align: right"]25[/TD]

[TD="align: center"]16[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]31-8-2018[/TD]
[TD="align: right"]235[/TD]
[TD="align: right"]24[/TD]

[TD="align: center"]17[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]31-8-2019[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]18[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]30-9-2018[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]3[/TD]

[TD="align: center"]19[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]30-9-2019[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]20[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]31-10-2018[/TD]
[TD="align: right"]-10[/TD]
[TD="align: right"]-1[/TD]

[TD="align: center"]21[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]31-10-2019[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]22[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]30-11-2018[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]3[/TD]

[TD="align: center"]23[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]30-11-2019[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]24[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]31-12-2018[/TD]
[TD="align: right"]-10[/TD]
[TD="align: right"]-1[/TD]

[TD="align: center"]25[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]31-12-2019[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

Sheet1​

 

[lunaticpandora]

That's solved my issue. Thank you so much!