I prepare a forecast histogram for staff and workforce employees on a monthly basis, based on our current projects and tenders. There's a chart for the staff, and a chart for the workforce. (refer attached - I've used a stacked area chart, with the Staff chart being the "master" format I'd like to follow).Format Series.xlsx

If I've formatted the series for Tender A on the Staff chart, I want to have the same format on the Workforce chart (and so on), however, not all of the tenders and/or projects will appear on both. Further, the list is dynamic and will change month to month as tenders are won or lost, and as projects finish.

The chart data is set up simply with the month as the "header row" and each Tender or Project listed under, with the corresponding forecast manning level. I can extract say the tender or job number to help uniquely identify the data set.

Is it possible to automate this?