Simple stacked? graph

[mariomp]

I'm trying to visually show usage change in my water bill for the past few years.
I don't even know what to call it, but ideally, I would like to see Jan19,Jan20,Jan21,Jan22,Feb19,Feb20... in x-axis and corresponding values in y-axis.
This should be incredibly simple, but I just don't know how to do it.

This is for my own use and doesn't need to be pretty or even labeled.
What's the easiest way to do this? Sort by month? If that's even possible.

power usage.xlsx

Date kWh/Month
Jan-19 109
Feb-19 89
Mar-19 95
Apr-19 112
May-19 128
Jun-19 132
Jul-19 140
Aug-19 170
Sep-19 190
Oct-19 125
Nov-19 135
Dec-19 121
Jan-20 139
Feb-20 150
Mar-20 155
Apr-20 150
May-20 139
Jun-20 227
Jul-20 253
Aug-20 230
Sep-20 176
Oct-20 166
Nov-20 154
Dec-20 229
Jan-21 154
Feb-21 146
Mar-21 124
Apr-21 182
May-21 232
Jun-21 463
Jul-21 275
Aug-21 423
Sep-21 535
Oct-21 365
Nov-21 317
Dec-21 304
Jan-22 251
Feb-22 249
Mar-22 217
Apr-22 332
May-22 474
Jun-22 600
Jul-22 743
Aug-22 639
Sep-22 464
Oct-22 448
Nov-22 415
Dec-22 341
Jan-23 356
Mar-23 611
Apr-23 498
May-23 780
Jul-23 1775
Aug-23 1119
Sep-23 763
Oct-23 611
Nov-23 633
Dec-23 507
Jan-24 356
Feb-24 424
Mar-24 479
Apr-24 590
May-24 861
Jun-24 1021
Jul-24 840
Aug-24 905
Sep-24 296

[AliGW]

Are you still using Excel 2010?

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

[mariomp]

Thanks. I've updated the OP.

[popipipo]

If you change the source layout you can create this line or stacked graph

[josephteh]

The simplest way is to use PivotTable & PivotChart.

[mariomp]

If you change the source layout you can create this line or stacked graph

Oh, I see. I never thought about creating multiple columns.
Thank you!

[mariomp]

The simplest way is to use PivotTable & PivotChart.

Thank you. Was moving data a manual copy/paste process or is there a function to move all the 2019 to one column and 2020 into the next, ... ?

[josephteh]

It's not a manual copy/paste process. Please read up about PivotTable.