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

lunaticpandora

New Member
Joined
Aug 5, 2019
Messages
2
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 :)
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
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:

ABCD
1monthDate#1#2
211-1-201820010
3131-1-201921513
4228-2-201820512
5228-2-201919511
6331-3-201821014
7331-3-201922517
8430-4-201821516
9430-4-201920515
10531-5-201822018
11531-5-201923521
12630-6-201822520
13630-6-201921519
14731-7-201823022
15731-7-201924525
16831-8-201823524
17831-8-2019
18930-9-2018153
19930-9-2019
201031-10-2018-10-1
211031-10-2019
221130-11-2018153
231130-11-2019
241231-12-2018-10-1
251231-12-2019

<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,504
Messages
6,114,016
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top