I suck at Excel Charts. I just need to aggregate transaction value by month. Any help?

[RockandGrohl]

Hi all, I'm trying to make a stacked bar chart which shows transaction values to certain Cryptocurrency exchanges by a fraudulent individual per month.

I've included two images - one is my data structure, and the second is what I want, loving drawn in paint.

https://imgur.com/a/t12HuVT

I just can't bloody get this to work. When I highlight the Text Data column, the Exchange column & the Amount column and then insert stacked bar chart, I just get this absolute mess where there's 15 May-21 entries, 6 Jun-21 entries etc.

I just want to see an amount transferred per month, according to which exchange it was sent to. I didn't think it would be this hard!

Thanks!

 

[RockandGrohl]

I managed to do it in PowerBI in less than 10 minutes, first try using Power BI.

Faffed around in Excel for ~2 hours.

A poor indictment of Excel. Thanks anyway!

 

[RockandGrohl]

Mods - please delete this post, thank you!