Chart showing Location, Date & multi category quantity

Hi,

I am not sure if this is possible and have dtruggled with it for some time, searched the web and not found what is needed. So any help is greatly appreciated.

I am trying to create a chart that shows the number of 2 categories across different countries over a period of time. So that progress can be seen of what is delivered.

My table is designed like:

Date 1 Date 2 Date 3
Item Type1 Item Type 2 Item Type1 Item Type 2 Item Type1 Item Type 2
Country1
Country 2
Country 3

I am trying to chart this in a stacked column chart so that the 2 item types show as a percent progress. i.e. as item 1 increases item 2 decreases. I need to reflect this for each country over the different dates. I have tried different approaches in excel but have been unsuccessful in producing anything that works.

Essentially output I would like to achieve would be:

Date 1 Date 2 Date 3 Date 4 Date 5
Country 1
Country 2
Country 3
10% 20% 30% 40% 50%...

Then the stacked bar for Item type 1 would show growth over time.

Is this possible or am I looking at this in the wrong way? A line chart with date points would be great to.

Thanks in advance for your kind help and time!

Kind regards
B