Hi all, I've got an Excel file that I'm trying to create a bar graph for. I've set up a macro to generate the dates I need to use, but have no experience on the graphing side

There are 5 dates for each item that are used, which are current date, run out date, due date, low stock date & a 90 day date. I'm wanting the graph to run from the current date to the 60 date with the following

The data for the graph changes with each due date, so line 1 of the example will provide the data for the graph until the due date, then line 2 provides the data for the graph until that due date. The last line of for the item has not due date and provides the data until the 60 day date

The bar graph should be red at the run out date
The bar graph should be yellow at the low stock date
The bar graph should be green if not red or yellow.

So, for the first occurrence of the line item the graph would be red until 1/20
Reading now from line 2, the graph would then turn green from 1/20 through 1/30, then turn yellow, which would carry through 02/01, when the PO due date is achieved.
The graph would become green through 02/07 where it would change to yellow. It would stay yellow through 02/21 when it hits the run out date and becomes red. It would stay red until 03/01 when the PO due is achieved.
The graph would then be green through 04/17 when the 90 day date is achieved. It would not change to yellow or red because the low stock and run out dates would not be reached before the 90 day date

The graph should be shown when clicking the Graph text on the last line for the specified item.

The process would then repeat for each item until column 1 is blank.

Thanks for any advice or help.

Forecast.xlsx