Chart with 2 data sets

Hi, i have 2 data sets in attached workbook that i wish to create a chart with.

There is already an embedded chart with 1 of the datasets which shows the life-status of hardware (in months) which is formatted that way i like it. But i wish to add a secondary axis on top or bottom to show the date in year as opposed to months. in the workbook the start date in cell H2 has a value of 0 months.

Is it possible to create this chart with this data?


hardware life chart.xlsx

thanks for that...

the complicating factor here is the stacked bar chart used for the original data.

When i try to add the secondary dataset, Excel re-plots the data in a way that moves the categories to the x-axis and undoes
the formatting.

i'll keep trying and post the solution here if i find it