Help on a to date value + further done visual

[LaurenceSD]

Hi,

I've hit a bit of a brick wall, wondering if anyone might be able to suggest a solution.

Context is a travel company, looking at bookings in the future. What I've got is essentially 3 tables, one containing the booking date, then a travel date table and a booking date table.

What i've managed to create with the below is departures for the current month and the next 12 months, with the equivalent to date figures (so for example the Blue bar represents bookings that traveled last year, but were booked prior to 7th February 2022). 

The bit i'm struggling to create is ideally, i'd like a stacked bar chart where i could add onto each year where they finished up

An example using a line chart is below - so here the blue line is the final position for last year - so to pick one example In June, at the same point last year we had done 21 bookings, but the final amount of bookings done for June 2022 was 34.

Now the combo of bar and line technically works, but for 6 years worth of data, it gets very messy & hard to read. Does anyone have a more elegant solution to get this all on one visual?

Thanks