Graph View Showing Product Journey Over Time

Hello

I have searched and tried a few suggestions but none seem to fit this instance.

I have a inventory of products

each day a inventory of the stock is recorded

each product therefore has a daily record of its status
there is many different status including on back order, for sale, sold out, future product etc

i have been able to calculate the earliest date and latest date for each status for each product

i am only interested in showing sold out and for sale data

based on the date range for each product for age status e.g. for sale 01/01/2023 - 12/09/2023 and 13/09/2023 -21/02/2024
would i be able to use date field from calendar table and on the graph show products available for sale at any one date?

This is example of graph i would like - showing in stock and out of order total products 

The current solution is a seperate table which contains count by status by date, however i would like the cross filter option to select a bar of the chart and find out further product details.

Thank you for any help or advice