I would recommend reshaping your data similar to the attached. This can be done using a Excel Reshaper tool. http://kb.tableausoftware.com/articles/knowledgebase/addin-reshaping-data-excel
Hope this helps!
Copy of Sample Data-1.xlsx 10.4 KB
I've reshaped the data per your recommendation.
Can you show me how you would plot actual vs scheduled using a bullet chart?
Thansk for your help.