Hi All

I need a VBA solution that will convert a table (see attached CalcSheet tab) and generate a stacked chart (see attached Skyline tab) ,sorting ID's numerically, based on the week ending date assigned. In addition, if possible, have the formatting align with the sample provided. The attached is pretty self explanatory.

Thanks in advance.

skyline.xlsx