Create Stacked Chart based on multiple fields

[CMcDonald]

Hello,

is it possible to create a bar chart like below when the Years are all separate fields?

CMcDonald_0-1726149421850.png

Example of my data below.  The coloured parts of the chart are from the "Status" field.

CMcDonald_1-1726149731590.png

This post was helpful but it's based upon a single field.
https://support.esri.com/en-us/knowledge-base/how-to-create-a-stacked-chart-in-arcgis-dashboards-000...

Thanks in advance